topic Re: Issue importing a txt file in QlikView

Issue importing a txt file

battistiandco — Tue, 07 Feb 2012 15:13:39 GMT

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

rbecher — Tue, 07 Feb 2012 15:33:04 GMT

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

battistiandco — Tue, 07 Feb 2012 15:56:52 GMT

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

battistiandco — Tue, 07 Feb 2012 16:37:07 GMT

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>

Re: Issue importing a txt file

flipside — Tue, 07 Feb 2012 16:51:01 GMT

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

Re: Issue importing a txt file

battistiandco — Wed, 08 Feb 2012 09:36:35 GMT

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>

Re: Issue importing a txt file

giuval45 — Tue, 16 Sep 2014 13:21:37 GMT

Hi Flipside,

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

Best regards,

Giulio

Re: Issue importing a txt file

Anonymous — Wed, 21 Nov 2018 13:08:44 GMT

Thanks a lot, it fixed my problem.