how to load a file from a folder,

Aubry — Fri, 17 Jun 2022 08:17:23 GMT

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

Re: how to load a file from a folder,

vinieme12 — Fri, 17 Jun 2022 08:23:13 GMT

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;