Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

battistiandco
New Contributor II

Issue importing a txt file

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 ?

1 Solution

Accepted Solutions
Highlighted
flipside
Valued Contributor II

Re: Issue importing a txt file

Hi,

Have you tried setting Quoting to none instead of msq?

Your load script will end something like ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

instead of ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

flipside

7 Replies
MVP & Luminary
MVP & Luminary

Issue importing a txt file

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

battistiandco
New Contributor II

Issue importing a txt file

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;;;;;;

battistiandco
New Contributor II

Re: Issue importing a txt file

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>

Highlighted
flipside
Valued Contributor II

Re: Issue importing a txt file

Hi,

Have you tried setting Quoting to none instead of msq?

Your load script will end something like ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', no quotes);

instead of ...

     (txt, codepage is 1252, embedded labels, delimiter is ';', msq);

flipside

battistiandco
New Contributor II

Re: Issue importing a txt file

Hi flipside

The right command was

(txt, codepage is 1252, embedded labels, delimiter is ';', no quotes, no

eof);

Thanks you very much for your help.

Rainer from Italy

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

**

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

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

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

Partner
Partner

Re: Issue importing a txt file

Hi Flipside,

many thanks and very helpful... "no quotes" worked perfectly...;-)

Best regards,

Giulio

pablo_nieto
New Contributor II

Re: Issue importing a txt file

Thanks a lot, it fixed my problem.