Convert all left input data to "Right_" data after Join

Question

Running my data through a Join tool and trying to figure out how to replace all the left input data with that from the "Right_" column while maintaining the column order from the left input in the fewest steps possible.  There has to be a method to do a bulk conversion with one tool or one formula but I can't figure it out.  Any ideas?

flying008 · Answer

Hi, @Rob48

Another dynamic solution for you:

myastarling · Answer

I don't know of one tool that will do this, but the attached workflow will do it.

ReplaceLeftWithRightAndOrder.yxmd

apathetichell · Answer

use a dynamic select to filter for fields with Right_ in the name. also maybe include recordID.

use a dynamic rename to remove "Right_"

you now have an fields from your original datasource rewritten with the right data.