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

       

      Sales:

      LOAD ColumnA as Ename,

           ColumnB as Year,

           ColumnC as Month,

           ColumnD as Sales,

           ColumnE as Target

      FROM

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

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