Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ffabio_79
Contributor II
Contributor II

Problem with csv file: skip records???

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

1 Solution

Accepted Solutions
amars
Specialist
Specialist

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

View solution in original post

3 Replies
ffabio_79
Contributor II
Contributor II
Author

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
Specialist
Specialist

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

View solution in original post

ffabio_79
Contributor II
Contributor II
Author

Brilliant!

Thanks a lot.