Where Exists Load

Fri, 26 Jul 2013 15:48:45 GMT

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...

Re: Where Exists Load

Mon, 29 Jul 2013 21:05:28 GMT

Thanks helped a lot!

topic Where Exists Load in QlikView

Where Exists Load

Re: Where Exists Load

Re: Where Exists Load