Discussion Board for collaboration related to QlikView App Development.
Is it possible to have a where statement referencing information in a file?
Where Email = (DOCUMENT/TXT FILE CONTAINING EMAIL ADDRESSES)
No that's not possible. You can first load the email addresses from the text documents in a separate table and then use the exists function in the where clause so you load only data containing the email addresses you loaded first from the documents.
You can use this:
WHERE $(Include=FileName.txt) ;
and in your file you can write:
Email = 'firstname.lastname@example.org'
No, but you could load the text file using
LOAD @1 As Line
FROM maillist.txt (fix, no labels);
Now use the field Line in your load script.