9 Replies Latest reply: Jun 28, 2017 6:31 AM by Matthew Quinn RSS

    Loading multiple qvd files and contenate them

    Do espirito Arnault

      hello,

       

      Does anybody know why this script creates severals tables Contenu, Contenu-1, Contenu-2 in place of concatenate them in only 1 ?

       

      Contenu_qvd:

      LOAD fichierqvd

      FROM

      [X:\QlikView New\ventes\QlikviewData\SourceDocuments\CONTENU\sources\Contenu_qvd.xlsx]

      (ooxml, embedded labels, table is Feuil1);

       

      For i=0 to NoOfRows('Contenu_qvd')-1

      LET vQVD = Peek('fichierqvd','$(i)','Contenu_qvd');

       

      CONTENU:

      LOAD *,

      filename() as Nomqvd,

      datepar&'|'&editionsec&'|'&folio as %key

      FROM ..\..\SourceDocuments\CONTENU\QVD_nrga\$(vQVD) (qvd);

       

      next i;

       

      I think that this script would work fine with .csv files isn't it ?

       

      Thank you very much in advance .

       

      Arnault