Combine Multiple excel files with same name containing in multiple folders

[ankurgupta16]

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

[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,

M.

[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 ?

[mceleavey]

Hi @ankurgupta16 ,

I've attached it as a package. You can only use that if you're on the latest version of Alteryx.

If not, in the original post, save the macros to your macro folder.

You can set your macro folder in the Options->User Settings->Edit User Settings->Macros tab.

M.

[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?

M.

[ankurgupta16]

Below are files. Zip is not supported so Need to rename the file ABC-2  and put them in multiple folders. In my Folders there are multiple files  in both folders