Merge multiple excel files into one

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.

Input

Output

Accepted answers

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

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 😀👍

Use the file name as *.xlsx