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