topic Problem with csv file: skip records??? in QlikView

Problem with csv file: skip records???

Anonymous — Wed, 17 Oct 2012 15:42:09 GMT

Hi all,

I'm having a problem in loading data from a .csv file. It seems QView doesn't load identical (regarding values) rows.

In attach an example: there are 12 rows in the source_data.csv file, while QV load only 8.

They should be 2 groups of 3 identical rows, but they have been loaded just one for each group (1st one?).

Fact: In the wizard preview, it shows ALL the records. Why are they missed afterwards?

Thanks in advance

Re: Problem with csv file: skip records???

Anonymous — Thu, 18 Oct 2012 08:18:47 GMT

I'm counting records for each DDT (document if transport) field and the result (12) is correct !

Load

DDT,

Count(DDT) as Numero_Righe

Resident DETTAGLI

Group by DDT

;

Why do I see only 8 lines in the Qview table? Is there an option that hide "duplicated" records?

Please help.

Re: Problem with csv file: skip records???

amars — Thu, 18 Oct 2012 08:42:28 GMT

Hi,

Check the attachment. Actually If you will see in your Data structure -> total No of rows (i.e. Ctrl + T & then move your cursor over the Table you can see that 12 rows are there but as there are duplicate rows, the one duplicate records are suppressed.

Please see the attached file.

Thanks

Re: Problem with csv file: skip records???

Anonymous — Thu, 18 Oct 2012 09:09:44 GMT

Brilliant!

Thanks a lot.