4 Replies Latest reply: Mar 1, 2016 3:39 AM by jagan mohan rao appala RSS

    Dynamic data load with titles names

    arjun rao

      Hi All,


      I want to load the data dynamically from the files likes Sales Data - 2015.xlsx,Sales Data - 2016.xlsx.

      Need to load the first sheet name is like Sales Data - 2015,Sales Data - 2016.


      Last two columns in the files are with Year names like Sales 2015,Sales 2016.


      Please check the attached file.


      I want to do like this but not sure how to achieve .

      Please advise. jagan mohan rao appala MAYIL VAHANAN RAMASAMY Celambarasan Adhimulam



      LOAD ColumnA as Ename,

           ColumnB as Year,

           ColumnC as Month,

           ColumnD as Sales,

           ColumnE as Target


      [ExternalData\Excel\Sales Data - 2015.xlsx]

      (ooxml, embedded labels, table is [Sales-2015]);