Load file monthly in Qlik

[intergnek]

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

[ramyasaiqv]

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

[intergnek]

ok thank you!