Input and Join

[meitata]

I have a file with multiple sheets and this is the header of sheets:

• A B C D E
• A B C D F
• A B C D G
• A B C D H
• A B C D I

Is it possible to join the file with header A B C D E F G H I with macro or less tools?

[AmalinaH]

** correction **

Apologies! I believe I misunderstood your question. For combining different sheets that have different schema, this discussion and solution posted here may have what you are looking for:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Multiple-Sheets-with-Different-F...

[meitata]

is it work if the data have different schema?

[AmalinaH]

This thread here looks like it has what you are looking for:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Multiple-Sheets-with-Different-F...

It would involve using a batch macro.

[grazitti_sapna · Accepted solution]

Hi @meitata, is this what you are trying to achieve from the input source having multiple schemas?

Let me know if that is what you are looking for?

Thanks!

[meitata]

Yes, that's what I lookin for! Lemme know how to do it? @grazitti_sapna 

[grazitti_sapna · Accepted solution]

@meitata, I have created a macro for this posting my workflow here.

Please go through it once and let me know if you have any questions.

Thanks!

[meitata]

Can you explain me what does File New in folder 2 contains? @grazitti_sapna 

[grazitti_sapna]

@meitata, it is just a file template that I used in the dynamic input tool for reference. It will be replaced with the filename passed outside the macro.

Thanks!

[meitata]

@grazitti_sapna okay, so I'll try it! Thanks a lot for your help!