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