I have a file with multiple sheets and this is the header of sheets:
Is it possible to join the file with header A B C D E F G H I with macro or less tools?
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, 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.
** 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-Formats/td-p/531961
is it work if the data have different schema?
This thread here looks like it has what you are looking for:
It would involve using a batch macro.
@grazitti_sapna bello! that's work!! thanks for your help!! I appreciate it!
@meitata, Glad I could help!
