6 Replies Latest reply: Sep 16, 2014 9:21 AM by Giulio Valeri RSS

    Issue importing a txt file

    rainer battisti

      I am trying to import a txt file with ; separator with 100000 rows.

      Only part of the file is imported.

      I have try to import it in MsAccess and all rows are imported.

      Can you help me ?

        • Issue importing a txt file
          Ralf Becher

          Hi,

           

          if no error occurs in QlikView I presume there are binary data in a record or an empty row in the file.

          Can you post your load command and some sample records..

           

          - Ralf

            • Issue importing a txt file
              rainer battisti

              No error occurs, but the rowsestracted  are only some and not adiacent

               

              This is the load comand

               

              Directory;

              LOAD [ID Garanzia],

                   [Codice Garanzia],

                   N.Prenotazione,

                   Fidelity,

                   [Punto vendita],

                   [Data vendita],

                   [Tipo Garanzia],

                   Articolo,

                   Marca,

                   Seriale,

                   [Valore Articolo],

                   [Valore Garanzia],

                   [ID Cliente],

                   Nome,

                   Cognome,

                   Indirizzo,

                   [Citta'],

                   Provincia,

                   CAP,

                   [Data inizio Garanzia],

                   [Data Fine Garanzia],

                   Aperta,

                   L1,

                   D_L1,

                   L2,

                   D_L2,

                   L3,

                   D_L3,

                   L4,

                   D_L4,

                   L5,

                   D_L5,

                   L6,

                   D_L6,

                   L7,

                   D_L7,

                   L8,

                   D_L8

              FROM

              [1_Garanzie.txt]

              (txt, utf8, embedded labels, delimiter is ';', msq);

               

               

              Some rows

              ID Garanzia;Codice Garanzia;N.Prenotazione;Fidelity;Punto vendita;Data vendita;Tipo Garanzia;Articolo;Marca;Seriale;Valore Articolo;Valore Garanzia;ID Cliente;Nome;Cognome;Indirizzo;Citta';Provincia;CAP;Data inizio Garanzia;Data Fine Garanzia;Aperta;L1;D_L1;L2;D_L2;L3;D_L3;L4;D_L4;L5;D_L5;L6;D_L6;L7;D_L7;L8;D_L8

              1;AAA6RILBIANCO10;0163080025447;0400103685478;CASTENEDOLO;04/11/2008;;WHIAWOD4112;WHIRLPOOL;859230538000;359,00;109,00;0;ROBERTO;MARCELLI;VIA BASALICA 10;CALVISANO;BS;25012;06/11/2008;11/11/2014;Aperta;64357;BIANCO;64358;LAVAGGIO;64359;LAVATRICI FRONTALI 60X60;64399;FINO 5 KG.;64400;DA 650 A 800 G;;;;;;

              2;AAA3RILPCDESK149;0163080025473;0400110276935;CASTENEDOLO;04/11/2008;;ACEASM5641;ACER;92E2RFPIBP8300DC312701;849,00;149,00;0;ALESSANDRO;TADINI;VIA GERONI 7;MONTICHIARI;BS;25018;04/11/2008;07/11/2011;Aperta;64375;I.T;64376;COMPUTER;64476;DESKTOP/TOWER;64477;STANDALONE;64496;INTEL;64638;DUALCORE***;;;;

              3;AAA3RILPCLAP169;0163080025490;0400113159709;CASTENEDOLO;04/11/2008;;TOSA3001IK;TOSHIBA;88292795Q;899,00;169,00;0;ENRICO;SABINO;VIA EUROPA 57;S.ZENO NAVIGLIO;BS;25010;05/11/2008;08/11/2011;Aperta;64375;I.T;64376;COMPUTER;64377;LAPTOP;64378;NOTEBOOK;64379;INTEL;64415;DUALCORE***;;;;

              4;AAA6RILBIANCO16;0163080025525;0400113156609;CASTENEDOLO;05/11/2008;;GOLWD12320RD;LG;610KWTA00297;999,00;169,00;0;DANIELA;STRADA.;DEL BOSCONE 2F;CASTENEDOLO;BS;25014;06/11/2008;11/11/2014;Aperta;64357;BIANCO;64358;LAVAGGIO;64531;LAVASCIUGA;64532;OLTRE 1000 GIRI;;;;;;;;

              5;AAA3RILPCLAP169;0163080025528;0400110275297;CASTENEDOLO;05/11/2008;;ACEA5930G844G25MN;ACER;LXAQ40X132826153842000;872,03;169,00;0;FABIO;LOIZZI;VIA GIUSEPPE PIROVANO 15;MONTICHIARI;BS;25018;05/11/2008;08/11/2011;Aperta;64375;I.T;64376;COMPUTER;64377;LAPTOP;64378;NOTEBOOK;64379;INTEL;64415;DUALCORE***;;;;

              6;AAA4RILTVPLA149;0163080025550;0400113159044;CASTENEDOLO;05/11/2008;;SAMPS50A416;SAMSUNG;Z5EB3SSQ803660;999,00;149,00;0;GABRIEL;SCARPIELLO;VIA DON LUIGI STURZO 8;MONTIRONE;BS;25010;05/11/2008;08/11/2012;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64364;PLASMA;64437;50;64438;HDTV;;;;;;

              7;AAA5RILTVLCD099;0163080025563;0400113155534;CASTENEDOLO;05/11/2008;;GOL32LG5700;LG;809WRPD2R488;678,00;99,00;0;VITTORIO;RONGA;VIA 25 APRILE 18;BRESCIA;BS;25121;05/11/2008;09/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64392;FULL HD;;;;;;

              8;AAA5RILTVLCD099;0163080025578;0400103835132;CASTENEDOLO;05/11/2008;;SAMLE32A436;SAMSUNG;AL8C3SCQA01336;532,53;99,00;0;DONATO ANTONIO;DI CHELE;VIA F. BARACCA 5;GHEDI;BS;25014;05/11/2008;09/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64395;HD;;;;;;

              9;AAA5RILTVLCD099;0163080025682;0400105287250;CASTENEDOLO;07/11/2008;;PHI32PFL7433D;PHILIPS;HJ3HO843430580;699,00;99,00;0;MARCO;PISONI;VIA VERDI 21;BOTTICINO;BS;25080;07/11/2008;11/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64391;32;64395;HD;;;;;;

              10;AAA5RILTVLCD129;0163080025691;0400106866805;CASTENEDOLO;07/11/2008;;GOL42LT75;LG;709WRJC48068;899,00;129,00;0;BRUNA;BESCHI;VIA DELLA RESISTENZA 7;CASTENEDOLO;BS;25014;07/11/2008;11/11/2013;Aperta;64362;CONSUMER ELECTRONIC;64363;VIDEO;64390;LCD;64508;42;64607;HD;;;;;;

              • Re: Issue importing a txt file
                rainer battisti

                Hi Ralf, I have understood the issue. In the file there are some rows with

                the " character. I attach an example.

                It's a bug o QlikView ?

                How I can do to skip this problem ?

                Thanks Rainer

                 

                2012/2/7 Ralf Becher <qliktech@sgaur.hosted.jivesoftware.com>

                 

                **

                     QlikCommunity <http://community.qlik.com/index.jspa>   Re: Issue

                importing a txt file  created by Ralf Becher<http://community.qlik.com/people/rbecher>in

                Connectivity and Data Sources - View the full discussion<http://community.qlik.com/message/189269#189269>