Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
It may sound basic but I would like to know.
I have an Excel file that I receive every month, and I have to arrange to load it into Qlik Sense every time it arrives.
For exemple:
TABLE:
LOAD
VILLE,
STATUS,
DATEVENTE,
MONTANT
FROM [lib://Connex_Distribution/Data\test.xlsx]
(ooxml, embedded labels, table is Feuil4);
How should I do it?
Thank you in advance
You can use * at the end of the file name and it will automatically load the data. Please make sure the file names should have same naming convention.
TABLE:
LOAD
VILLE,
STATUS,
DATEVENTE,
MONTANT
FROM [lib://Connex_Distribution/Data\test*.xlsx]
(ooxml, embedded labels, table is Feuil4);
Ramya
ok thank you!