Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
can somebody shortly explain how the load...where exists function works or tell me a solution for my problem?
Following:
I have different tables with the Email as a key field
table 1: field1 as Email
table 2: field1 as Email
table 3: field1 as Email
table 4: field1 as Email (join table 3)
table 5: field1 as Email (join table 3)
I have now a CSV which gives you additional information about the person/email add, but I only want to load that ones whose exists in my previous tables (1-5).
So it should be something like:
Information_Email_table:
LOAD
field1 as Email,
field2,
...
FROM
Information_Email_table.CSV
where Exists(Email)
But QV tells me that it can' t find the field Email...
Hi
Please refer , it helps to learn about exists
http://community.qlik.com/message/190743#190743
http://community.qlik.com/message/286660#286660
Usage of "exists"http://community.qlik.com/message/336906#336906
Hi
Please refer , it helps to learn about exists
http://community.qlik.com/message/190743#190743
http://community.qlik.com/message/286660#286660
Usage of "exists"http://community.qlik.com/message/336906#336906
Thanks helped a lot!