Alteryx Running Total ID, only change when related column changes

[HenpetsGordres1]

Hello,

Using a Multi-Row Formula, how would I create the ID column below?

I have tried the following to no avail:

IF [Location] = [Row-1:location] THEN [ID] = [ID]
ELSE [ID]+1
ENDIF

Many thanks.

[afv2688 · Accepted solution]

Hello @HenpetsGordres1 ,

You almost got it right:

IF [Location] = [Row-1:location] THEN [Row-1:ID]
ELSE [Row-1:ID]+1
ENDIF

[Greg_Murray]

try this:

if location = [Row-1:Location]

then [Row-1:ID]

else [Row-1:ID] +1

endif

[fmvizcaino]

Hi @HenpetsGordres1 ,

Try to do as attached workflow.

Let me know if that works for you.

Best,

Fernando Vizcaino

[neilgallen]

unless you need to get more complicated with your criteria, I prefer to use the tile tool with the following settings:

Tile Method: Unique Value

Unique Column: Location (make sure "Leave Unsorted" is checked)

And then use the "Tile_Num" as your new ID field.

as like most things with alteryx, there are a number of ways to solve the problem!

[HenpetsGordres1]

Thanks!