Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
0li5a3a
Creator III
Creator III

how to create a new field based on two tables

Hello,

 

I have  2 tables and I want to create a new field based on the information from both.

Tab1:

id, site, surname

1, London, Emy

2,Poole,Eny

 

Tab2:

ID, Product, Site

1, Apple,London

2,Apple,Luton

3,Orages,Luton

4,Plumes,London

5,Kiwi,London

 

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 :

Tab3:

ID, Product, Site, Yes/No

1, Apple,London,Yes

2,Apple,Luton,No

3,Orages,Luton,No

4,Plumes,London,Yes

Resident Tab2;

Thanks in advance! 

 

Labels (1)
1 Solution

Accepted Solutions
Gysbert_Wassenaar

Something like this using the Exists() function:

Tab3:

LOAD *, If(Exists(site, Site), 'Yes', 'No') as [Yes/No]

Resident Tab2;


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar

Something like this using the Exists() function:

Tab3:

LOAD *, If(Exists(site, Site), 'Yes', 'No') as [Yes/No]

Resident Tab2;


talk is cheap, supply exceeds demand