Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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