multiple pairs of 'columns' and 'right_columns' (like columns1, right_columns1, columns2,

[ayush_mishra]

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.

[SPetrie · Accepted solution]

Take a look at this post. 

I have an example workflow there that may help.

[ayush_mishra]

thanks @SPetrie  it's a life saver when you have to do this on 50+ columns. Appreciate your help!