topic where statement referencing file in QlikView

where statement referencing file

Tue, 07 Oct 2014 12:49:22 GMT

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

Re: where statement referencing file

Gysbert_Wassenaar — Tue, 07 Oct 2014 12:53:15 GMT

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.

Re: where statement referencing file

Anonymous — Tue, 07 Oct 2014 12:53:37 GMT

You can use this:

WHERE $(Include=FileName.txt) ;

and in your file you can write:

Email = 'xxx@xxx.com'

Regards,

Gabriel

Re: where statement referencing file

jonathandienst — Tue, 07 Oct 2014 13:06:55 GMT

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