Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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
gabriel_kirst
Creator III
Creator III

You can use this:

WHERE $(Include=FileName.txt) ;


and in your file you can write:

Email = 'xxx@xxx.com'


Regards,

Gabriel

jonathandienst

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