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

[#1]

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.

[JonnyPoole · Accepted solution]

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 .

[#3]

Thanks. It's working.