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

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

Workflow

Accepted answers

AbhilashR

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.

sample.yxmd

jrgo

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.yxmd

All comments

AbhilashR

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.

sample.yxmd

jrgo

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.yxmd

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703