How to combine two excel spreadsheets with different column headers?

Question

Hello! I am trying to figure out how to combine report 2 data into report one but the column headers are different between the two reports. For example, I want to pull put the "Sales Document" data from Report 2 into the "Sales Order Num" column in Report 1.

Report 1.xlsx

Report 2.xlsx

nagakavyasri · Answer

Try this by joining

Sales order number.yxmd

ChrisTX · Answer

You can use a Select tool to manually re-name columns, then a Union tool to combine the two data streams.

Or to fix the column names using a macro, check out this example: Design Pattern – Easily changing field names – Alter Tricks

Chris