2 Replies Latest reply: Jan 6, 2018 6:59 PM by Pot?? Amaud Gnekohi RSS

    Load file monthly in Qlik

    Pot?? Amaud Gnekohi

      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