Issue with Multi Row Formula

[mystasz]

Hello!

I have the attached sample input and expected output. Seems pretty simple, just can't get the formula correct. The tool is creating another column called "NEWNAME". If the ID is the same, apply the name across the same ID. This is just a sample of the data and my real data is about 800K rows so I'd prefer using a multi row formula if possible:

This is what I have that does not work:

IF [ID] = [Row-1:ID]
then [Row-1:NAME]
else [NAME]
endif

[gawa · Accepted solution]

hi @mystasz 

Thing is that you should refer to [Row-1:NEWNAME] instead of [Row-1:NAME] to copy the previous row value.

You can simply rephrase your expression to:

IF [ID] = [Row-1:ID]
then [Row-1:NEWNAME]
else [NAME]
endif

 FYI, it looks like this.

[mystasz]

Ahh yes! Thank you so much. @gawa