Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

where statement referencing file

Is it possible to have a where statement referencing information in a file?

For example:

Load 8*

Email,

...

Name,

....

Where Email = (DOCUMENT/TXT FILE CONTAINING EMAIL ADDRESSES)

Many thanks

3 Replies
Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

You can use this:

WHERE $(Include=FileName.txt) ;


and in your file you can write:

Email = 'xxx@xxx.com'


Regards,

Gabriel

jonathandienst
Partner - Champion III
Partner - Champion III

Hi

No, but you could load the text file using

     MailList:

     LOAD @1 As Line

     FROM maillist.txt (fix, no labels);

Now use the field Line in your load script.

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein