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

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

Sample_CreatingNewColumn_AK.yxmd