Column header adjustment - Consolidated File

Kaish

Hi all, I am facing a issue in adjusting column headers of different files, the headers are same ex- Name column but the same headers are different for different files ex. NAME, name. Therefore while consolidating the data I get multiple columns. Kindly guide me the steps so that I can create an output. Below I am attaching the data and this is what I want to achieve as shown in the Image. Kindly Support.

Orders 1.xlsx

Order 2.xlsx

Consolidated File.xlsx

Gaurav_Dhama_

Quickest way to do this is by using "auto Config by position" in union tool, given that the column position remains same always.

Another method is:

If column name is consistent but just case differs e.g., Name, name, NAME etc.

• Then you can use dynamic rename, select all the fields and write the formula
  TRIM(UPPERCASE([_CurrentField_])).
• This formula will make all the column headers as Upper case and remove any additional blank spaces.
• Now you can use "Auto Config by Name" in Union tool.

If this answers your question, please mark this as solution.