Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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