I have multiple columns that need to be replaced with another column with the same name - one such example is below:
I want to replace this column from source one:
with this column from source two:
I know i could do this for one change using the formula tool and just making the 1st one equal the 2nd one, but how would I do the above for multiple columns without having to write alot of formulas?
Im currently using a join but this adds "right_" to the 2nd column and I would have to manually reposition them as well.
Thanks!