Load using variable in .csv filename

varmekontrol — Fri, 17 Jan 2020 12:23:57 GMT

I am trying to use a variable in the .csv file I intend to load on a daily basis, and because of this, I am using today() as a reference.

But for some reason, nothing I do makes me able to use today() in the filename I want to load.

Let vCreatedDate = date(today(), 'YYYY-MM-DD'); Let vFileName = 'PropertyErrorList_$(vCreatedDate).csv'; AMM_Property_error_list: LOAD id, message, propertyNumber FROM [c:\property_error_list\Data\$(vFileName)] (txt, unicode, embedded labels, delimiter is ';', msq);

Re: Load using variable in .csv filename

marcus_sommer — Fri, 17 Jan 2020 14:55:08 GMT

Try it in this way:

Let vFile = 'PropertyErrorList_' & date(today(), 'YYYY-MM-DD') & '.csv';

AMM_Property_error_list:
LOAD id, message, propertyNumber
FROM [c:\property_error_list\Data\$(vFile)]
(txt, unicode, embedded labels, delimiter is ';', msq);

- Marcus

topic Re: Load using variable in .csv filename in QlikView

Load using variable in .csv filename

Re: Load using variable in .csv filename