Start Free Trial

Alteryx Designer Desktop Discussions

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

separating a date range into separate rows

markbanlawe
7 - Meteor

 

Good day,

 

Could i get your inputs on how i can separate a date range into single dates per row?

 

Example:

 

1/18/2021 - 1/22/2021

 

Output desired

1/18/2021

1/19/2021

1/20/2021

1/21/2021

1/22/2021

 

Hope you can help me 

4 REPLIES 4
randreag
11 - Bolide

hi @markbanlawe 

 

You can separate the date and use a generate rows

I attached an example

 

I hope it helps

messi007
15 - Aurora
15 - Aurora

@markbanlawe,

 

Please see below:

messi007_0-1611242476476.png

Attached the workflow,

Hope this helps,

 

Regards,

markbanlawe
7 - Meteor

thank you trying it now

messi007
15 - Aurora
15 - Aurora

@markbanlawe,

 

If this helps! please make it as solved it will help others 🙂

 

Best Regads,

Labels
Top Solution Authors