
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Where Exists Load
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...
- Tags:
- join
- load
- where_exists
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Please close the thread by marking correct answer & give likes if you like the post.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks helped a lot!
