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

Record count not starting at 1

Trip
6 - Meteoroid

After counting a table, I want to use the result to start a record number.

 

So if the count is 1000, the first number needs to be 1001 then 1002 and so on.

 

I uploaded a sample of what I am trying to do.

 

I tired using what I have in the sample.  Also tried the multi-row formula but that did not work either.

 

Thanks

3 REPLIES 3
ChrisTX
15 - Aurora

Try the attached workflow

 

ChrisTX_0-1626723829794.png

 

 

Chris

Trip
6 - Meteoroid

That worked great.  Thank you

Jean-Balteryx
16 - Nebula
16 - Nebula

Hi @Trip ,

 

I twisted a little bit your formula tool by making the sum of the first record ID and your count to get your new record ID.

See attached workflow.

 

EDIT : I didn't get what you needed. Now that I do I modified your workflow accordingly.

 

Capture d’écran 2021-07-19 à 22.11.16.png

Labels