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
20 - Arcturus

@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
20 - Arcturus

@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