Alteryx Analytics Hub

Find answers, ask questions, and share expertise about Alteryx Analytics Hub.

Need to divide the date range

swapsingh2712
8 - Asteroid

Hello All,

 

I've a data set where for a particular test, there's an activation date  and decommision date columns. I want to transform that data set into a new file where it shows all the dates that are mentioned between  activation date  and decommision date columns in one column. The format should be in mm/dd/yyyy format.

 

For example if the activation date is 1/1/2018 and decommission date is 8/30/2018. the new transformed column should show dates like this

 

1/1/2018
2/1/2018
3/1/2018
4/1/2018
5/1/2018
6/1/2018
7/1/2018
8/1/2018

 

I've attached the screenshot for better understanding

 

Could you please help

 

BR,

swapsingh

 

 

1 REPLY 1
Joe_Lipski
13 - Pulsar
13 - Pulsar

You need the Generate Rows tool for this task!

I've attached a workflow which hopefully solves your challenge:

 

Joe_Lipski_0-1636986131204.png

 

Joe Lipski
Labels