Keep duplicate values while loading

[vireshkolagimat]

Hi,

I have data in the below format and i want to keep duplicate values after reload.

By default qlikview stores the distinct values. How to overwrite this behavior.

Header 1	Header 2	Header 3
Group A
category1
category2
Group B
category1
category2

If i reload the above data, it will load only the rows Group A,category1, category2,Group B and i will miss out another 2 rows.

Regards,

Viresh

[sunny_talwar]

That is not true, QlikView won't keep distinct values unless you tell it to. You won't see the duplicate values in a table box, but that doesn't mean they are not loaded.

Try doing a count of them in straight table.

Dimension:

Header 1

Expression

Count([Header 1])

[sunny_talwar]

Here is an example to look at

Table box show a single A, but Table Viewer show 2 As

[marcus_sommer]

Even that qlik stored only unique values you won't loose duplicate values if you don't apply a DISTINCT within your load. But you will need an unique row-identifier with recno() and/or rowno() to see those duplicates within a tablebox which will only show unique field-combinations.

- Marcus

[vireshkolagimat]

Hi, in this case,i want to see both A in a table.

[sunny_talwar]

Then as marcus_sommer‌ mentioned below add another field using RowNo() or RecNo() which assign each instance of A a unique identifier and use that identifier in your table box object