cancel
Showing results for 
Search instead for 
Did you mean: 

Row generator not working for large numbers?

IguanaVerde
Meteoroid

Row generator not working for large numbers?

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
IguanaVerde
Meteoroid

Row generator not working for large numbers?

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

 

 

Highlighted
DataNath
17 - Castor

Re: Row generator not working for large numbers?

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.