1 Reply Latest reply on Jul 15, 2016 9:27 PM by Dmitry Chirkov

    Union of Excel Worksheets with dynamic naming




      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