How to merge Multiple sheets if the number of headers are not fix your alteryx.

[Ekmi9]

How to merge Multiple sheets if the number of headers are not fix your alteryx.

 Sample Input:- 

Please Note My alteryx version is 2020.2 

Thanks in advance !

[grazitti_sapna]

Hi @Ekmi9, is this what you are looking for? You can achieve this using a macro. Attaching yxzp file along with this post. 

As you are using an older version of alteryx extract the yxzp file then right-click on the yxmd file then open it in notepad and change the alteryx version as per your version.

I hope this helps!

Thanks!

[Ekmi9]

In your input number of headers is fix i.e 5 but that not in my case i have different number of headers in each sheet 

[grazitti_sapna]

@Ekmi9, can you share a sample input file?

Thanks!

[Ekmi9]

And number of sheets are also not fixed 

[grazitti_sapna]

@Ekmi9, The workflow I shared is not fixed to only five columns or sheets try inserting additional columns in File 1 that I shared it will still work.

Try changing my input source to yours and check if it works for you?

Use the below configuration.

Hope this helps!

Thanks!

[Ekmi9]

I am facing error on input text tool 

let me know what's needs to put in that ?

why we need that static information.

[grazitti_sapna]

@Ekmi9, can you post the error screenshot?

Thanks!

[Muhai]

Hi, you may try the instructions in the link below.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

Thanks