topic Re: How to get duplicates when sending data to excel from table box? in QlikView

How to get duplicates when sending data to excel from table box?

Tue, 02 Sep 2014 13:48:14 GMT

Hi,

I have data in excel where ID in excel have duplicates. I created qvw to load the excel data to match with data from database. I created a table box. when I am sending te data from table box to excel the duplicate IDs are showing only once. how can I get the duplicates.

Please can anyone suggest me.

Thanks.

Re: How to get duplicates when sending data to excel from table box?

JonnyPoole — Tue, 02 Sep 2014 13:53:57 GMT

The recommendation is to add a new unique field in the load using say recno()

Load

recno() as Indentifer,

from <Source>

Then in your table box add all the fields including the indentifier and export to excel.

Table box suppressed duplicates .

Re: How to get duplicates when sending data to excel from table box?

Tue, 02 Sep 2014 14:08:01 GMT

Thanks. It's working.