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.