Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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 = 'xxx@xxx.com'
Regards,
Gabriel
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