I’m trying to figure out a way to get data from ‘Table B’ to ‘Table A’ based on the value of a field in Table A.
It looks as follows:
I have an entry in Table A, for which I select ‘device’, ‘pagetype’ and ‘country’. For the combination of these three fields I want to create a unique identifier, so I’ve added a formula column:
This would result in for example MobileHomepageGermany.
In Table B I have set a ‘value’ for MobileHomepageGermany of 100. I want to lookup this value and add it to a column in Table A.
So I add an entry, select device, page, and country, and then I want the value to show up in that Table in that row.
I’ve been trying to figure this out for 1,5 hours, but its probably a simple solution right?
Thanks in advance.