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. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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

Adding a new column in ascending order

missteran
7 - Meteor

How can I create a new column where the row counts in ascending order? counting from 1 through whatever number the final row falls?

 

Goal "New Column" :

IDNew Column
6886541541
35487874542
4787843
64687874
879874185
548676546
548748457
54564548
48746639
23263569510
54641154511
131564541212
5145152413
514547854714
69646321315
2 REPLIES 2
Emmanuel_G
13 - Pulsar

@missteran 

 

Use RecordID tool.

 

Emmanuel_G_0-1663855967427.png

 

missteran
7 - Meteor

Thank you simple, love it!

Labels
Top Solution Authors