Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to increment row number starting from Zero

thd-data-analyst
7 - Meteor

Hello,

 

I need to assign row number to groups of data in a table. My table is like this:

 

ProductCategoryAttributeValue
100123Cat1Att1Blue
100123Cat1Att1Green
100123Cat1Att1Yellow
100123Cat1Att1Orange
100127Cat2Att1Power Wash
100127Cat2Att1Oil Change
100127Cat2Att1Fluids Top-up
100130Cat1Att2Stainless Steel Drum
100130Cat1Att2Programable Timer
100130Cat1Att2Fuzzy Logic
100130Cat1Att2Auto Shut-off
100130Cat1Att2Water Saving
100135Cat2Att1Power Wash
100135Cat2Att1Oil Change

 

I need a new Position column that starts from zero and increments by 1 for each item in the group. I was able to add the increments using a Multi-row formula, but I don't know to start the numbering from zero. Can anyone suggest how I can do that?

 

I have attached my workflow to the question.

12 REPLIES 12
atcodedog05
22 - Nova
22 - Nova

Hi @thd-data-analyst 

 

You give a look at Tile tool it's tile sequence gives a similar effect as record ID on grouby when configured to unique value

 

https://help.alteryx.com/current/designer/tile-tool

 

Hope this helps 🙂

thd-data-analyst
7 - Meteor

Thank you @atcodedog05  and @TheOC . You guys rock. 🕺

atcodedog05
22 - Nova
22 - Nova

Happy to help 🙂 @thd-data-analyst 

 

Cheers and Happy Analyzing 😀

Labels