Multi Row Formula: Enter text under T-1 Row

[bubblyjai1982]

Hi All,

Need your assistance I'm beginner and learning Alteryx !! Using Multi Row Formula I want to have the output in below format.

If Row 0 contains "Payment to Counterparty" then Row -1 should be "Payment to Counterparty" otherwise Null ().

In other words want to have text of Row 0  under Row -1

I tried using below formula but output is incorrect...IF contains([Comments],"Payment to Counterparty") Then [Row-1:Comments]=[Row-1:Comments] Else Null()ENDIF

Please find the workflow and input file. 

Many Thanks

Bubbly

[apathetichell]

If Row+1 contains "Payment to Counterparty" then  "Payment to Counterparty" otherwise Null ().

you are chanigng the value of a file in row 0- so check row+1 for value.

[binu_acs · Accepted solution]

@bubblyjai1982 

[bubblyjai1982]

Perfect !!

Thank you for quick response