Combine Multiple excel files with same name containing in multiple folders

Hi All,

I have a requirement where in I have two Folders each having multiple files with same names . I want to combine the files with same name . Each file has multiple tabs.

Folder 1

File 1 - Sheet 1,2,3

File 2 - Sheet 1,2,3

Folder 2

File 1 - Sheet 4,5

File 2 - Sheet 4,5

Output expected

Folder 3

File 1 - Sheet 1,2,3,4,5

File 2 - Sheet 1,2,3,4,5

Data Investigation

Accepted answers

All comments

mceleavey

Hi @ankurgupta16 ,

I've attached an example file. I've built a couple of tools to do exactly this.

The first tool loads in the sheet names and appends them to the file name, the second loads them in and unions together.

You just need to re-point in the directory tools.

Hope this helps,

Multi Sheet Import Example 2.yxmd

Dynamic Multi File Sheet Names.yxmc

Import Multiple Schema Flat Files.yxmc

ankurgupta16

Thanks for the prompt reply, I am having trouble using it as I am new to ALTERYX, Do you think we can achive this without Macro

ankurgupta16

Can you please upload as a package ?

ankurgupta16

Thanks you mceleavey ! I got my ALTERYX upgraded

It partly worked. Two queries

1) I am getting below error

2) My sheets dont have same data structure

mceleavey

@ankurgupta16 ,

can you share a couple of the files so I can see the data structure?

Also, can you confirm they are .xlsx files?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703