Creating New Column using Formula Tool

[EricMartinson]

Hello!

I am merging updated info from one document into the second to update specific fields without changing the original fields that are correct.

I'm creating 12 new columns using the Formula Tool like this:

This accomplishes my goal but is there a more efficient way to do this?

I thought maybe the Multi-Field Formula Tool:

Select "Right_" fields as fields to update and using this IIF statement:

IIF(([OJAN] = NULL()), [Right_OJAN], [OJAN])
IIF(([OFEB] = NULL()), [Right_OFEB], [OFEB])

But I couldn't get this to work. Thank you in advance for your feedback!

[AkimasaKajitani · Accepted solution]

Hi @EricMartinson 

I created a workflow that uses the Formula Tool instead of the Multirow Formula Tool.
The data is once held vertically and then put back.

Correction File

Original File

Output

Solution

[EricMartinson]

@AkimasaKajitani this is perfect. Thank you!