Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

intergnek
New Contributor III

Load file monthly in Qlik

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

2 Replies
ramyasaiqv
Contributor II

Re: Load file monthly in Qlik

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
New Contributor III

Re: Load file monthly in Qlik

ok thank you!