I got a question regarding a union of multiple Worksheets in one Excel.
I know that I am able to create a union from an existing Excel Connection, just adding the sheets.
The thing is, I have an Excel with multiple sheets (one per year) just starting with the same Prefix. The years may vary. Sometimes there are 20, sometimes 10 different years, only the Prefix stays the same.
Can a Union be dynamic about this?
I thought maybe with a legacy connection and custom SQL but wouldn't know how that could work.
Any help is appreciated
Thanks a lot
Yeah, unfortunately this is currently not available. Not even with Legacy/Custom SQL (since that one is more strict and would require table/sheet names).
Did you know that you can select multiple sheets and drag them all into union dialog?