Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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