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
15 - Aurora
15 - Aurora

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

@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