Solved: Qlikview eliminating duplicate lines when loading ... - Qlik Community

Report Inappropriate Content · ‎2012-11-21

Hi all,

I have the below code:

-----------------------------

LOAD @1 as [Reporting Entity],

@2 as UBR,

@3 as FSI,

@15 as [Group Settlement Amount],

@18 as Description,

@19 as [Receiving FSI],

@21 as Period

FROM

(txt, codepage is 1252, no labels, delimiter is ';', msq, header is 1 lines);

------------------------------

I have a CSV file with a content below:

V4.0;GL;R;Delta;IF;;11-19-2012;10985;100

8423;7052;1770111000;;;;;;;;;;;;2726.94;;;6520_FILE000154_rajwlal_20121119;1770109000;;201101

When I constructed a table box, there is only 1 row appearing. This leads me to believe that qlikview is automatically eliminating duplicates when loading?

If this is correct, is there a way to reconfigure this so that Qlikview loads the data as it is e.g. all the 10 rows above?

Thanks

flipside · ‎2012-11-21

Hi,

The TableBox object will only display one of the rows. You can check this by creating the same layout in a straight table chart and setting the Expression to count({field}) or something, it will show how many identical lines there are.

You would probably be wise to add a RowNo() column to your load script and include it in your table object or use the dual function to pair this RowNo() value to one of your fields.

flipside

View solution in original post

swuehl · ‎2012-11-21

QV will load all rows, but a table box will only show distinct combinations of your field values.

If you do a count on one of your fields (or using the table viewer CTRL-T), you'll see that all lines are read in.

Hope this helps,

Stefan

flipside · ‎2012-11-21

Hi,

The TableBox object will only display one of the rows. You can check this by creating the same layout in a straight table chart and setting the Expression to count({field}) or something, it will show how many identical lines there are.

You would probably be wise to add a RowNo() column to your load script and include it in your table object or use the dual function to pair this RowNo() value to one of your fields.

flipside

Qlikview eliminating duplicate lines when loading from CSV file?