topic Re: Duplicates in Table Box in QlikView

Duplicates in Table Box

Anonymous — Thu, 30 Jul 2015 11:46:04 GMT

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

Re: Duplicates in Table Box

rubenmarin — Thu, 30 Jul 2015 11:48:41 GMT

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.... ;

Re: Duplicates in Table Box

Anonymous — Thu, 30 Jul 2015 11:52:17 GMT

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

Re: Duplicates in Table Box

Anonymous — Thu, 30 Jul 2015 11:52:36 GMT

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

Re: Duplicates in Table Box

awhitfield — Thu, 30 Jul 2015 11:54:06 GMT

Ha ha,

duplicate replies in a call about duplicates!

Re: Duplicates in Table Box

rubenmarin — Thu, 30 Jul 2015 11:55:05 GMT

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.... ;

Re: Duplicates in Table Box

Anonymous — Thu, 30 Jul 2015 11:57:36 GMT

Thanks Marin

Appreciate it