Alteryx Designer Discussions

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

Entering A Sequence Number for Date

KamenRider
8 - Asteroid

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
17 - Castor

@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
8 - Asteroid

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