We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Row generator not working for large numbers?

IguanaVerde
6 - Meteoroid

Hi All

 

I am trying to set up the row generator function as per below to generate new rows based on columns InvoiceNr1 and Invoice Nr3. I want to see one row for each invoice number between those two numbers. As you can see, I already added instructions to the Row generator but it come out with no values. Do you know why, am I setting it up wrong , am i tackling it the wrong way perhaps? I know i am close but 

 

Alteryx Row Add.JPG

 

 

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @IguanaVerde, if I'm reading this right, I think you ought to be using:

 

Invoice <= InvoiceNr3

 

At current, you're telling Generate Rows to only create rows whilst Invoice >= InvoiceNr3 which it never is, as it takes the starting value from InvoiceNr1 which is always smaller.

Labels
Top Solution Authors