Load files with datestamp

[stekol61]

I am trying to load data form different files.

I use this expression:

Let vFile = 'SS_Core_KPI-1-4G_Attach_SR-' & date(today(), 'YYYY-MM-DD'&'.csv');

LOAD *
FROM
[\\sehan5863asqva3.tcad.telia.se\Qlik QDF DEV\1.Group\3.Applications\11.Bile_Core\8.Import\Felix\$(vFile)]
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

The problem is that the filename contains both date and HH-MM. And HH-MM differs from day to day.

How can this be handled?

SE_Core_KPI-1-4G_Attach_SR-2021-06-29-01-00.csv

/Stefan

[Fred · Accepted solution]

Hi Stefan,

You could use wildcards to pick up the files and completely disregard the time in the file name.
Only works if a file is dropped once a day and if you don't really care about the time.

I used  the '?' wildcard for the time format in your file name.

LET vFile = 'FileName-' & date(today(), 'YYYY-MM-DD') & '-??-??.xlsx';

LOAD
*
FROM [lib://ConnectionName/$(vFile)]
(ooxml, embedded labels, table is Sheet1);

Good luck!