Problem with csv file: skip records???

[Anonymous]

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

[Anonymous]

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.

[amars · Accepted solution]

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

[Anonymous]

Brilliant!

Thanks a lot.