if I have multiple pairs of 'columns' and 'right_columns' (like columns1, right_columns1, columns2, etc) and I want to use formula below for each pair.
IF IsNull([right_columns]) THEN [columns] ELSE [right_columns] ENDIF
do I need to do this for each column using formula tool or is there a efficient way? These are coming from Join tool.
Solved! Go to Solution.
Take a look at this post.
I have an example workflow there that may help.
thanks @SPetrie it's a life saver when you have to do this on 50+ columns. Appreciate your help!