1 Reply Latest reply: Jul 15, 2015 6:04 PM by Kenny Hua RSS

    Create QVD with a CSV file, XLSX (Créer un QVD avec un fichier CSV, XLSX)

    Kenny Hua

      Hello,

       

      I front a rather annoying problem because many post talks about the STORE command. Me as soon as I want to use this control I have this problem: ODBC connection failed

       

      My script is linked with an FTP to get CSV files, XLSX to turn them into QVD:

       

      XLSX:

      LOAD

         *;

      SQL SELECT

         *

      FROM [ftp: // AAA: VVV@11.111.11.111/DV/nom_du_fichier.csv] (txt, codepage is 1252 embedded labels, delimiter is ';', no quotes)

       

      * FROM STORE XLSX.qvd into XLSX (qvd);

       

      If anyone can enlighten me on this.

       

      Best Regards

       

      Translated with Google Translate - Qlik Community Administrative Team

       

      Bonjour,

       

      Je devant un problème assez ennuyant car, beaucoup post parle de la commande STORE. Moi dès que je veux utilise cette commande j'ai ce problème : ODBC connection failed

       

      Mon script est lier avec un FTP pour prendre les fichiers CSV, XLSX pour les transformer en QVD:

       

      XLSX:

      LOAD

        *;

      SQL SELECT

        *

      FROM [ftp://AAA:VVV@11.111.11.111/DV/nom_du_fichier.csv] (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

       

       

      STORE * FROM XLSX into XLSX.qvd(qvd);

       

      Si quelqu'un peut m'éclaircir sur ce sujet.

       

      Cordialement

        • Re: Créer un QVD avec un fichier CSV, XLSX
          Onno van Knotsenburg

          Translation (by Google Translate):

           

          Hello,

           

          I before a pretty annoying problem because many post talks about the STORE command. Me as soon as I want to use this command I have this problem: ODBC connection failed

           

          My script is using an FTP link to take the CSV, XLSX to turn them into QVD:

           

          XLSX:

          LOAD   *;

          SQL SELECT   *

          FROM [ftp: // AAA: VVV@11.111.11.111/DV/nom_du_fichier.csv] (txt, codepageis1252embeddedlabels, delimiter is';',no quotes);

           

          Does the LOAD go correct? I doubt it as it seems like you added an SQL statement while trying to load a CSV file. That is the reason you are getting an error.

           

          Your script should probably look like this:

          XLSX:

          LOAD   *

          FROM [ftp: // AAA: VVV@11.111.11.111/DV/nom_du_fichier.csv] (txt, codepageis1252embeddedlabels, delimiter is';',no quotes);

           

          After that you want to store that file into a QVD file. To do so, add this line of script:

           

          STORE XLSX into xlsx.qvd;