Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Qlikview eliminating duplicate lines when loading from CSV file?

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

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

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

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

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

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

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

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

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

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

1 Solution

Accepted Solutions
flipside
Partner - Specialist II
Partner - Specialist II

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

2 Replies
swuehl
MVP
MVP

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

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