1 Reply Latest reply: Sep 26, 2014 1:10 PM by Nagaraj Rangaiah RSS

    Excel Load

      Dear Guru's,

       

      i have requirement, where i have to import data from excel as attached.

       

      Data is in format of sheet 1 and we need the data to be in format of sheet 2.

       

      request to let me know how to load this data, thanks in advance

        • Re: Excel Load

          Dear Friends,

           

          Found the answer ....

           

          Table:

          LOAD @1 as Country,

               @2 as State,

               @3 as Region

          FROM

          Data.xlsx

          (ooxml, no labels, table is SystemFile, filters(

          Transpose(),

          Replace(1, top, StrCnd(null)),

          Replace(1, top, StrCnd(null)),

          Replace(2, top, StrCnd(null))

          ));