Generate rows by datedif

[maxiemens]

Hey guys, following problem: I want to generate rows by the following conditions:

I have an order ID,the order date and delivery date: For every month between the two dates I want to generate a new row like this:

What I want is extend the data until the deliverydate.

can you help me with this task? 😮 

[AngelosPachis · Accepted solution]

Hi maxiemens, 

You would have to configure the Generate Rows tool as shown in the picture below :

[MarqueeCrew]

@maxiemens ,

as another solution,  to be built a CReW macro to simplify the creation of rows for dates and times:

https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14 https://gallery.alteryx.com/#!app/Generate-Date-Rows/5e31f42a826fd30ffcbf2c14 

cheers,

 mark