How to use record ID with two or more rows that are equal?

[Joker_Hazard]

Hey guys.

I am trying to record ID using as a reference the column "Week Number".

So basically, I need that Alteryx stores as number one the values "27" and so on.

Example:

1 2020-07-07 00:00:00 27
1 2020-07-08 00:00:00 27
2 2020-07-15 00:00:00 28
3 2020-07-20 00:00:00 29
3 2020-07-21 00:00:00 29
3 2020-07-23 00:00:00 29

Is there any way of doing that?
Thanks

[AbhilashR · Accepted solution]

Hi @Joker_Hazard, i am guessing the Unique Value method in the Tile tool should help you:

Attached is a baseline workflow for you to build upon. TileNum buckets Field2 in my example as 1,2,3 etc, while TileSequenceNum computes the values within a given bucket. Think of it as 1.1, 1.2 etc.

[jrgo · Accepted solution]

Hi @Joker_Hazard 

You'd want to use either a multi-row formula tool or the Tile tool. See attached workflow...

Hope this helps!

Jimmy

[Joker_Hazard]

Is it possible to make it start at a certain number? like 30 or 40... instead of 1.

[Joker_Hazard]

Is it possible to make it start at a certain number? like 30 or 40... instead of 1.

[jrgo]

Yes, but would likely require you to use the Multi row tool

IF [Row-1:Week Number] = 0
THEN 30
ELSE [Row-1:WeekID] + 1
ENDIF