RecNo or RowNo to show duplicates ?

[claudialet]

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

;

[agni_gold]

[Table]:

LOAD

RecNo()  as RecordID,

[Sales] ,

[Order] ,

[Total],

[SortOrder] ,

RESIDENT [Table];

DROP TABLE [Table];

RENAME TABLE 

to

;

[claudialet]

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]

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.