Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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
16 - Nebula
16 - Nebula

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
Top Solution Authors