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
Solved! Go to 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.
You'd want to use either a multi-row formula tool or the Tile tool. See attached workflow...
Hope this helps!
Jimmy
Is it possible to make it start at a certain number? like 30 or 40... instead of 1.
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