Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

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

How to add a specific number of rows with Generate Rows tool?

Abdelrahmanmahdy
7 - Meteor

Dear All,

 

How can I add a specific number of rows.

I want to divide  the value of warranty for 24 month . So, I want to add 24 rows with 30 days interval.

When I added the rows with row count <=700 that is because the Payment term calculated in the example is 30. ( see the attached image)

if the payment term calculated is changed the 700 should be changed. 

How can I fix the number of rows regardless the payment term calculated value?

Thanks in advance.

 

2 REPLIES 2
gawa
16 - Nebula
16 - Nebula

@Abdelrahmanmahdy 

How about re-write condition expression like this?  With this, total increment is always the same regardless of the initial value(=Payment Term Caclulated) 

image.png

Qiu
21 - Polaris
21 - Polaris

@Abdelrahmanmahdy 
How about we take a bit detour.

First we generate 1 -24 then multiply it by 30 so it would be 30 days interval?

1128-Abdelrahmanmahdy.png

Labels
Top Solution Authors