Alteryx Designer Discussions

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

Multi-Row formula tool for rows more than 1 removed from current row

5 - Atom

Can anyone tell me why [Row+1:Column1] works but [Row+2:Column1] throws the error "Unknown Variable "Row+2:ColumnName"?

The posts I have found show that rows other than +1 and -1 should work as part of a multi row formula, but I can't get this to work.  What errors can I look for?

 

This is part of an IIF statement

 

IIF([Column1]=1, "NA",
IIF([Row+1:Column1]=1 AND [Row+2:Column1]!=1, [Column2]+"-"+[Row+2:Column2],
IIF(Row+2:Column1]=1, [Column2]+"-"+[Row+3:Column2],
[Column2]+"-"+[row+1:Column2])))

 

Many thanks for you help!

Alteryx Certified Partner
Alteryx Certified Partner

Within the Multi-Row formula there is a configuration setting for "Num Rows".  If you increase that value, you'll be able to search against 2, 3 or more rows.

 

Capture.png

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
16 - Nebula
16 - Nebula

@JenM Row+2 should work so long as you've selected at least 2 rows in the "Num Rows" option:

Capture.PNG

 

The default is 1, so you would have to manually change it to be 2. Let me know if you've already done that and it's still throwing an error!

5 - Atom

Brilliant - thank you! Error solved.

5 - Atom

Can we set the number of rows field based on a parameter?

9 - Comet

arghhhh so obvious thank you!!!

Labels