Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Linking the number of generated rows with the predefined number

Kamran1991
11 - Bolide

I want to create a repayment schedule of a loan, In the 'Input Text' tool, I have entered Loan Amount, Tenure, ROI and Start Date to repay.  I want to link the RowCount in Condition Expression with Tenure i.e. number of rows for repayment installment should be equal to Tenure(months).

 

Please help me to solve it

1.PNG

2.PNG

  

2 REPLIES 2
mbarone
16 - Nebula
16 - Nebula

You can open the expression editor window for your condition expression by clicking on the 3 dots to the right.  You can just replace the 60 with the field name.  Or, you could just enter it directly with brackets around the field name (that's the same thing the editor will do).  

atcodedog05
22 - Nova
22 - Nova

Hi @Kamran1991 

 

You can update your formula like this. @mbarone mentioned you can open formula editor for row gen tool and apply condition below.

 

atcodedog05_0-1628795485169.png

 

Hope this helps : )

 

Labels
Top Solution Authors