Problom loading .CSV file

[#1]

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

[#2]

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

[Anonymous]

Alfredo

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

Best Regards,     Bill Markham

[fred_s]

Hi Alfredo,

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

[rustyfishbones]

Hi,

Create a Text Object in Qlikview

=SUM([$Rows])

Reload the file, does it read 3942?

[#6]

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

[#7 · Accepted solution]

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

Regards

[rustyfishbones]

I have loaded the CSV and I still get 3942

here is what the load Script looks like

[Anonymous]

Alfredo

I make that 3,496 rows.

What were you expecting ?

Best Regards,     Bill