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

[Rob48]

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?  

[myastarling]

could you provide an example of what you are trying to do? 

[KGT]

Do you need it to be dynamic or not?

For a solution that you can use quickly each time to achieve it, you probably want to get control of the options menu in Join and select. You can set up your field info in the way you want and then save that as a yxft file (Options > Save/Load > Save field configuration) and then laod that into any select type interface. Once it's loaded, the file is not a dependency. This is a manual way, but it's an easy way to apply a field config.

Also check out in that menu things like:

• Clear all renames;
• Add/Remove prefix;
• Select > Remove all Left/Right;

If you are after something more dynamic or bespoke, then as @myastarling mentioned, an example would be useful.

[Rob48]

I'm using a Join tool to combine two excel files and need to replace the column data from the left input with the identically named columns from the right input.  Imagine a post-join data as below, but with 50 more columns of "Title n" and "Right_Title n."  There are also many more columns from the Left Join data that are not present in the Right Join data that I can ignore.  all columns are interspersed. The goal is to populate all the original (left input) columns with data from the right, while keeping the column order from the left inputs the same. 

Replacing the left data is easy, I know I can do this directly in the Join tool by deselecting the left columns and clearing the "Right_" prefex.  It's the second part of the operation, moving the new data into the same column positions.  it's very manual to reorder within the Join tool or a subsequent Select tool, so I was looking for a tool or short tool sequence after the join to do it for me.  Formula is a pain to do each column individually so I've fooled around with Dynamic Rename and Multi-Field Formula but can't get it to work.  

Also I know I can do this once and be done when doing it with the same files every time, but I will frequently get files with completely different columns & data, so unless I can come up with a dynamic, repeatable operation regardless of the column names i'm forced to repeat the manual process.  Thanks for any help you can provide!

Join Key	Title 1	Title 2	Title 3	Right_Title 1	Right_Title 2	Right_Title 3
Matthew	AAA	Red	Foosball	MMM	Purple	football
Mark	BBB	Orange	Billiards	OOO	White	baseball
Luke	CCC	Yellow	Darts	PPP	Black	basketball
John	DDD	Green	Cricket	QQQ	Mauve	hockey
Paul	EEE	Blue	Soccer	RRR	Polka Dot	football
George	FFF	Indigo	F1	SSS	Paisley	baseball
Ringo	GGG	Violet	Marathon	TTT	Striped	basketball

[apathetichell]

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.

[myastarling]

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

[flying008]

Hi, @Rob48 

Another dynamic solution for you: