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 !
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!
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
And number of sheets are also not fixed
@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!
I am facing error on input text tool
let me know what's needs to put in that ?
why we need that static information.
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