Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
claudialet
New Contributor III

RecNo or RowNo to show duplicates ?

Hi here is my script . This load contains duplicate rows and I need to display the duplicates in a table.

Where do I place the RecNo ()   or RowNo ()  to do this ?

[Table]:


LOAD


[Sales] ,

[Order] ,

[Total],

[SortOrder] ,

   

RESIDENT [Table];

DROP TABLE [Table];



RENAME TABLE 

to
    ;

3 Replies
agni_gold
Valued Contributor II

Re: RecNo or RowNo to show duplicates ?

[Table]:


LOAD

RecNo()  as RecordID,

[Sales] ,

[Order] ,

[Total],

[SortOrder] ,

  

RESIDENT [Table];

DROP TABLE [Table];



RENAME TABLE 

to
    ;

claudialet
New Contributor III

Re: RecNo or RowNo to show duplicates ?

so how do I use  Rec () as a dimension in a pivot table to show duplicates ?

The dimension in this case would be  Order.

JustinDallas
Valued Contributor II

Re: RecNo or RowNo to show duplicates ?

Hello Claude,

I would do something like this:

DATA:

LOAD * Inline

[

'FirstName'

    'Jean',

    'Claudia',

    'Van Damme',

    'Claudia'

]

;

DATA2:

LOAD *,

AutoNumber(RowNo(), FirstName) AS 'DupeCount'

RESIDENT DATA

;

DROP TABLE DATA

;

EXIT Script

;

I got this information from here:

How to show all duplicates with help of Rowno()

Also, I'm not sure how the RowNo() interacts with the AutoNumber function in the least.