Multirow formula to add 1 when the value of a column row becomes different

[JamesPorter]

Hi all,

I am very new to alteryx and learning a lot where I can from these forums...but I'm stuck so please be kind!#

I am trying to use the multi-row formula to populate the item no field.

Basically, I want it to start at 1, then if the next row is the same keep as one, when the part number changes as in row 5, then it needs to go to 2, and all the subsequent parts that are the same stay as 2, until the part changes (i.e. line 9) then it goes to 3...so on and so forth--but I cant get it to work.

Would anyone be able to help me and point me to the correct direction please?

[binuacs]

@JamesPorter this can be achieved using multirow tool as well as tile tool, sample workflow attached

[JamesPorter]

Ahhhh many thanks. So if I was to add a component column for instance, and I want to count components from 1,2,3,4,5 etc, but when the new part number changes, for that count to reset to 1 how does that work?

Basically, as the new part number changes, it resets the item no for component to 1

[binuacs]

to achieve that you need to group by the new part number field 

Note: the tile tool has both the values already there

[JamesPorter]

That brings back the rows as null?