Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
how to load a file from a folder,
without knowing the name of the file,
the name of the file changes every day
exemple : 20220615030009_EXPPV.csv
thank you for your reply
thx
Aubry Marcucci
Use wildcard(*)
To load all csv's in a folder
Load *
From lib://somepath/*.csv;
To load all csv's starting 2022
Load *
From lib://somepath/2022*.csv;
To load all csv's containing
Load *
From lib://somepath/2022*EXPPV.csv;
To load all csv's ending EXPPV
Load *
From lib://somepath/*EXPPV.csv;