How to combined data from two excel file into 1

[Learner09]

Hello,

I am trying to copy data from two different excel files into a single excel file but unable to design Alteryx flow. Can anyone help me to design the flow for the same?

What I am trying to do, I have two files saved on the different location File1 and File2 and I wanted to consolidate file1 and file2 data into the final file

[Emil_Kos · Accepted solution]

Hi @Learner09,

Hope it helps.

[Amarendra · Accepted solution]

Hello,

You can achieve this using the Union tool. You configure the tool to "Auto Config by Name" and also set a specific order for both your files. See attached