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

Serialize rows

BJSOON
8 - Asteroid
Hi, I have an output containing multiple columns and rows. I would like to add a column whereby to serialize (1, 2, 3, 4, 5 etc) my rows. I tried multi row formula but it returned blank. Appreciate your advice!
3 REPLIES 3
JoeS
Alteryx Alumni (Retired)

Do you mean to add a number that increments itself by one for each record?

 

If so the Record ID tool in the preparation section does just that.

BJSOON
8 - Asteroid
Thank you!
JoeS
Alteryx Alumni (Retired)

You're welcome 🙂

Labels
Top Solution Authors