We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Generate Rows for n times until Date reaches certain condition

tseo
7 - Meteor

 Hi 

 

I have a data set of dates, (2023-06-30~ 2023-07-08)

and I would like to add 1 day for each date, repeating until first date reaches last date. 

 

I think I could use generate rows tool, but since i'm quite new, I thought I could get some help from here.

 

Any help would be very appreciated.

 

Thanks!

 

 

4 REPLIES 4
binuacs
21 - Polaris

@tseo One way of doing this

image.png

tseo
7 - Meteor

it seems like it is not what I wanted.

my output should have 64 rows(8*8) but your workflow only generates 43 rows.

tseo
7 - Meteor

my idea

binuacs
21 - Polaris

@tseo below are the counts of each date to the last of the given date. Are you expecting a different output then?

 

image.png

Labels
Top Solution Authors