Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
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
Valued Contributor II

Re: Qlikview eliminating duplicate lines when loading from CSV file?

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

2 Replies
MVP
MVP

Re: Qlikview eliminating duplicate lines when loading from CSV file?

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
Valued Contributor II

Re: Qlikview eliminating duplicate lines when loading from CSV file?

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

Community Browser