Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Loading External Files

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

1 Solution

Accepted Solutions
Employee
Employee

Re: Loading External Files

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

4 Replies
Employee
Employee

Re: Loading External Files

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);

Not applicable

Re: Loading External Files

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

Employee
Employee

Re: Loading External Files

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

Not applicable

Re: Loading External Files

Thanks Clever Anjos. This worked perfectly.