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 ....



          LOAD @1 as Country,

               @2 as State,

               @3 as Region



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


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

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

          Replace(2, top, StrCnd(null))