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?
Solved! Go to Solution.
** 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:
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.
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!
Yes, that's what I lookin for! Lemme know how to do it? @grazitti_sapna
@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!
Can you explain me what does File New in folder 2 contains? @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!
@grazitti_sapna okay, so I'll try it! Thanks a lot for your help!