Multi-row formula?

[bsolove123]

I would like to make the null row in the attached dataset equal to the value of the cell directly below the null, plus the word "LOGIC". Is there any way to do this with the multi row formula tool?

[Qiu · Accepted solution]

@bsolove123 
A simple Multi-row formula should do it.

[leefarrell]

Add the Multi-Row Formula Tool: Drag it onto your workflow and connect it to your dataset.

Configure the Tool: Set it to operate on the row you want to update. In the "Expression" section, use a formula like this:

scss
Copy code
IIF(ISNULL([CurrentRow]), [Row+1] + " LOGIC", [CurrentRow])
This formula checks if the current row is null. If it is, it takes the value from the row below and appends " LOGIC". If it’s not null, it keeps the original value.

Adjust for Field Names: Replace [CurrentRow] and [Row+1] with your actual field names if they are different.

This will replace the null values with the desired text based on the value below.