Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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