Data Consolidation

[praveenpotturi]

Hi,

I have customer data in multiple excel sheets and i need to consolidate them in one excel sheet. Customer details in each excel sheet are different but headers are common in all sheets. How can I do this?

Ex: Workbook1

Cust ID	Cust Name	Loc
234	XYZ	US

Ex: Workbook2

Cust ID	Cust Name	Loc
435	UIH	IN

Ex: Workbook3

Cust ID	Cust Name	Loc
456	OIU	UH

Expected Result/workbook:

Cust ID	Cust Name	Loc
234	XYZ	US
435	UIH	IN
456	OIU	UH

[MarqueeCrew · Accepted solution]

If the sheet names are common and the file names are similar or if these are the only files in the directory , you are in luck! You can configure an input tool from one of the files and then modify the name with a wildcard (*) and all of the files will be read. Easiest solution possible.

If that isn't the case, you can configure input tools from each and bring the data together into a union tool. That's a pretty easy consolation solution too.

Cheers,

Mark

[praveenpotturi]

Thank you. I was able to do it by Union Tool.