Merge multiple tabs

[pierrejames]

I'm trying to merge multiple tabs/sheets from one excel file into one sheet or database. The columns/fields are all similar.

[atcodedog05]

Hi @pierrejames 

You can use dynamic input tool.

https://community.alteryx.com/t5/Interactive-Lessons/Connecting-to-Multiple-Sheets-at-Once/ta-p/8287...

Hope this helps 🙂

[Raj_Singh1]

hi @pierrejames 

if you can share a sample data sheet and desired out , would be good and i can try.

however solution can be used using "dynamic input" tool. it can be searched on Alteryx website or community page

[mceleavey]

Hi @pierrejames ,

I've built a couple of tools that allow for this without having to do the same thing over again.

I've attached an example workflow and the two tools you'll need (save the tools to your macro folder.

I hope this helps.

M.

[pierrejames]

I like this but I'm still having a little trouble.... please take a look.

[pierrejames]

I like this but I'm still having a little trouble.... please take a look.

[pierrejames]

Raj,

Here is a sample

[mceleavey]

Hi @pierrejames ,

The example I provided fixes this.

M.

[pierrejames]

@mceleavey 

It's a little difficult to follow your workflows I haven't used those tools before? Would you perhaps have detailed instructions or a video I can follow?