Discussion board where members can get started with QlikView.
I have 2 tables and I want to create a new field based on the information from both.
id, site, surname
1, London, Emy
ID, Product, Site
The 'site' from Tab 1 = 'Site Tab 2 .
I want to create a new field in Tab 2 based on this condition:
if(site exists in Tab 2 put Yes else no) how I can do this in Qlikview?
My new table need to looks like this :
ID, Product, Site, Yes/No
Thanks in advance!
Something like this using the Exists() function:
LOAD *, If(Exists(site, Site), 'Yes', 'No') as [Yes/No]
View solution in original post