In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
binu_acs
21 - Polaris

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

Vivek007ktd
7 - Meteor

@binu_acs Thanks for the help :)

Labels
Top Solution Authors