We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Formula: Count

MosesAddai24
7 - Meteor

What function in the formula tool can be used to create a column where entries represent the respective row numbers?

4 REPLIES 4
Allan_F
7 - Meteor

Think you are looking for the "Record ID" function under "Preparation" tools.

You can rename the RecordID Column if you like.

RecordID Example.pngRecordID Example2.png

Qiu
21 - Polaris
21 - Polaris

@MosesAddai24 

It would be better if you can provide a sample input and output?

MichaelSu
Alteryx Alumni (Retired)

Hi @MosesAddai24 ,

 

You can also use the multi-row formula tool to perform a count.

 

MichaelSu_0-1626392532030.png

 

 

Thanks,

Mike

MosesAddai24
7 - Meteor

It worked. Thanks!

Labels
Top Solution Authors