Duplicates in Table Box

[Anonymous]

Hi ,

I recently got to experience that the table box removes duplicate rows in its view. However we need duplicate rows in the data. Is there a way we can show the duplicate rows as well?

Thanks,

Sunny

[rubenmarin]

Hi Sunny, you can add a field wich have different values for each row, this way there will be no row with all values duplicated:

LOAD ...

     RowNo() as RowId

FROM.... ;

[Anonymous]

Hi Ruben,

Thanks for quick response. This could work, however I have data from 3 tables which I am concatenating in the script.

If I add Rowno in each of the 3 scripts, won't it start from Row 1 in each script? causing duplicates again

Thanks

[Anonymous]

Hi Ruben,

Thanks for quick response. This could work, however I have data from 3 tables which I am concatenating in the script.

If I add Rowno in each of the 3 scripts, won't it start from Row 1 in each script? causing duplicates again

Thanks

[awhitfield]

Ha ha,

duplicate replies in a call about duplicates!

[rubenmarin · Accepted solution]

There are many ways to avoid that, one simple way can be add a string identifying the table:

table1:

LOAD ...

     'T1.' & RowNo() as RowId

FROM.... ;

table2:

LOAD ...

     'T2.' & RowNo() as RowId

FROM.... ;

[Anonymous]

Thanks Marin

Appreciate it