Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Entering A Sequence Number for Date

KamenRider
10 - Fireball

Good day guys,

 

I would like to ask for your thoughts on how I am going to put a workflow for the following scenario.

 

I have dates and I would like each date be numbered so I can filter the needed dates. An overview sample is below. I would like all highest or current date to be sequence # 1. Please advise how I am going to do that.

 

KamenRider_0-1659026787682.png

 

 

Looking forward for your kind assistance. 

 

Thanks,

Kamen

3 REPLIES 3
binuacs
20 - Arcturus

@KamenRider One way of doing this with the tile tool or Multi-Row tool

 

binuacs_0-1659027399328.png

 

 

Emmanuel_G
13 - Pulsar

Hi @KamenRider ,

 

The Tile tool is exactly made for that.

 

Find the workflow attached.

 

Emmanuel_G_0-1659039858872.png

 

KamenRider
10 - Fireball

Thanks @Emmanuel_G  and @binuacs . Both ideas are applicable. I have used the tile tool but I was not able to get the highest date as the sequence number 1. The ideas of selecting unsorted solve the problem. Thanks for sharing your ideas. Appreciate it much.

 

Kamen

Labels