How to Join multiple files and merge information to avoid duplication.

[fteplits]

Can someone help me understand how I can join multiple excel files together with the same schema of 3 columns (account name, debit balance, credit balance) in 12 monthly excel files with different amount values posted? The excel files are for each month and some accounts may be different from month-to-month as well. I want to combine all of the excel files so that way the accounts won't have duplicates and the debit and credit balances will be presented horizontally.

[Qiu]

@fteplits 
Check out this macro.

https://community.alteryx.com/t5/Public-Community-Gallery/Import-Multiple-Excel-Workbooks-amp-Multip...

[grazitti_sapna]

@fteplits , try using Multiple join on the basis of Account Name. Here is one example with the sample input schema as per your requirement.

Thanks!!