Loading External Files

[#1]

Hello all,

I recently have been working in Qlik Sense as a primary BI reporting tool. The project requirements will be to persist a specific data set using .csv data load via Qlik through an internal directory. So far, everything has worked very smooth. However, looking further down the road, our file names will be getting changed on a monthly basis (primarily date in the name).

Is there a way to write the from path in a way to accommodate this?

Example:

FROM [lib://DataMart/ReportData\SourceDocs\BestEx.MMYYYY.Customer.YYYYMMDD.HHMMSS.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

Thanks in advance!

Eddie

[Clever_Anjos]

You want to read any files with that format?

FROM [lib://DataMart/ReportData\SourceDocs\BestEx.MMYYYY.Customer.YYYYMMDD.HHMMSS.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

[#3]

Yes, I would want to be able to read the most recent file using this format. Ideally, I would prefer to not have to routinely update my script to account for the new file name.

Thanks,

Eddie

[Clever_Anjos · Accepted solution]

Using this you can loop over each file into your folder.

You can create some logic to find out which file is the newest one

[#5]

Thanks Clever Anjos. This worked perfectly.