Qlikview eliminating duplicate lines when loading from CSV file?

Wed, 21 Nov 2012 09:21:53 GMT

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

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

swuehl — Wed, 21 Nov 2012 09:25:56 GMT

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

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

flipside — Wed, 21 Nov 2012 09:28:42 GMT

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

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

Qlikview eliminating duplicate lines when loading from CSV file?

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

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