Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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
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
MVP

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>

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>

giuval45
New Contributor III

Re: Issue importing a txt file

Hi Flipside,

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

Best regards,

Giulio

pablo_nieto
New Contributor

Re: Issue importing a txt file

Thanks a lot, it fixed my problem.

Community Browser