topic Problom loading .CSV file in QlikView

Problom loading .CSV file

Wed, 06 Nov 2013 19:40:09 GMT

Hello everyone,

i have a problem loading a CVS file, the file contains 3942 records and Qlikview only reads 3590, has anyone experienced something similar?, im attaching the file that cant be fully readed

Regards

Re: Problom loading .CSV file

Wed, 06 Nov 2013 19:56:15 GMT

Hi Alfredo,

This works fine here, all 3,942 records are being loaded:

LOAD [Teclee la clave],
     [Teclee la descr],
     [Teclee la unida],
     [Teclee el preci],
     Family,
     tip
FROM
[PROD.csv.xls]
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Re: Problom loading .CSV file

Anonymous — Wed, 06 Nov 2013 20:01:28 GMT

Alfredo

How are you counting that QlikView only loads 3,590 rows ?

Best Regards, Bill Markham

Re: Problom loading .CSV file

fred_s — Wed, 06 Nov 2013 20:40:50 GMT

Hi Alfredo,

I can confirm 3.942 recs.
Are you loading these as part of a join or something similar?

Re: Problom loading .CSV file

rustyfishbones — Wed, 06 Nov 2013 20:51:08 GMT

Hi,

Create a Text Object in Qlikview

=SUM([$Rows])

Reload the file, does it read 3942?

Re: Problom loading .CSV file

Wed, 06 Nov 2013 21:45:20 GMT

Sorry guys indeed that file reads good but the problem is with this one i post the wrong file, here is the right one

Re: Problom loading .CSV file

Wed, 06 Nov 2013 21:52:19 GMT

Its done just had to change the quoting from MSQ to Standard thanks anyway guys

Regards

Re: Problom loading .CSV file

rustyfishbones — Wed, 06 Nov 2013 21:53:32 GMT

I have loaded the CSV and I still get 3942

here is what the load Script looks like

Re: Problom loading .CSV file

Anonymous — Wed, 06 Nov 2013 21:53:57 GMT

Alfredo

I make that 3,496 rows.

What were you expecting ?

Best Regards, Bill