Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Generate max of record ID as a field

Vivek007ktd
7 - Meteor

Hi All,

 

Is there any option to populate the max of record ID as a new field? For eg, If the input data contains 222 records, I want a new field hardcoded with the max of record id '222'.

2 REPLIES 2
binuacs
20 - Arcturus

@Vivek007ktd You can use the summarise tool and take the max of the RecordID field and append with the append tool

Vivek007ktd
7 - Meteor

@binuacs Thanks for the help :)

Labels