Merge multiple excel files into one

[beatrizmguerreiro]

Hello, 

I have two folders:

* Input

* Output. 

I am inserting the multiple input source files (.xlsx format) in the "input" folder. They have the same schema.

I need to merge all into one (with .xlsx format) and place it in the "output" folder.

I don't know how to do it. 

The workflow I have built doesn't provide all files, only the first one.

Thank you for your help, in advance.

[atcodedog05]

Hi @beatrizmguerreiro 

Use the file name as *.xlsx

[JosephSerpis · Accepted solution]

Hi @beatrizmguerreiro you might find this post helpful as it provide a guide of the approaches you can take to tackle this in Alteryx.

[atcodedog05 · Accepted solution]

Hi @beatrizmguerreiro 

Actual filename

Changes filename

It will read all in folder

The highlighted filename is changed to .xlsx

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[beatrizmguerreiro]

What about the output tool configuration?

What options should I choose?

[JosephSerpis]

Hi @beatrizmguerreiro after you merged the data you can just output a single file which I presume what you want to do on your machine or a network location you have access too. This Tool mastery post on the Output Tool might help you.

[beatrizmguerreiro]

It doesn't work. It keeps retrieving only the first file, instead of all files.

[atcodedog05]

Hi @beatrizmguerreiro 

Since you want to put all data in a single output file. No changes in output tool as it is.

Additionally you set the highlighted option in input tool so that you get to know which file the data is from

Scroll down and check all your data.

Hope this helps. Please check and let me know.

[beatrizmguerreiro]

It doesn't work.

It keeps retrieving only the first file, instead of all files.

I look into the Metadata, from the full path, I can see it's only taking the 1st file. 

[JosephSerpis]

Hi @beatrizmguerreiro what approach are you taking? The guide in the post that I shared earlier has instructions for each approach is their something specific you are stuck on?