community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

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

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!

Highlighted
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.

@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!

Atom

Brilliant - thank you! Error solved.

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

arghhhh so obvious thank you!!!

Labels