3 Replies Latest reply on Nov 8, 2016 5:18 AM by P B

    Is it possible to include dynamic list of Excel files as data sources? If now, what would you do to include data from it?

    P B

      Hi Guys,

       

      I am currently working on a task where i have multiple excel files as sources. Every week new one is created with name based on the following nomenclature:

      filename_weeknumber.xls

       

      So the list looks like this:

      Data_W01.xls

      Data_W02.xls

      Data_W03.xls

      Data_W04.xls

      ...

      Data_W43.xls (created today)

       

      Is it possible to somehow include the data from the newest week without manual action?

      If not, what would be your proposal to consolidate the data and to include new .xls every week without any admin touch?

       

      Thaniks in advance.