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
20 - Arcturus
20 - Arcturus

@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