Free Trial

Alteryx Designer Desktop Discussions

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

Multi Row Formula Functionality

Sreecharan
5 - Atom

Hi All,

Advance Happy New Year to you and your family!

I've a query reg Multi Row Formula. I'm not able to understand how this Update existing field and Create New field works in the configuration window. When I try to use below formula and create new field it's not updating the rows correctly while Updating existing field works as expected. Could someone pls help me out. Pls find the attached example for more insights. 

Formula used: IF IsNull([Year])
THEN [Row-1:Year]
ELSE [Year]
ENDIF

 

 

1 REPLY 1
Sreecharan
5 - Atom

IF IsNull([Year])
THEN [Row-1:NewField]
ELSE [Year]
ENDIF

It worked

Labels
Top Solution Authors