1 Reply Latest reply: Jul 6, 2015 3:20 PM by Sinan Ozdemir RSS

    how to map the data?

      DATATEMP:

      LOAD

      GEO&'.'&[Operating Area]&'.'&[Sales_Region]&'.'&Territory&'|'

      &upper(ACCOUNT_SEGMENT)&'|'

      &[Hyperion Budget Unit]&'.'&SCBU&'|'&left(Fiscal_Period,4)&'-Q'&Right(Fiscal_Period,1)

      as [~MasterKey],

      Pipe

      FROm

      [C:\Users\BOYPR01\Desktop\Office\PIPELINE GAP\DATA.xlsx]

      (ooxml, embedded labels, table is Data);

       

      • I am actually trying to build a master key
      • I want to add the PNCV as [NCV Type] as column in the code
      • i want to add this before Hyperion budget unit
      • how can I achieve it?
        • Re: how to map the data?
          Sinan Ozdemir

          Hi Raghu,

           

          I am hoping I understand your question correctly. You can achieve that with another preceding load statement:

           

          LOAD

              GEO&'.'&[Operating Area]&'.'&[Sales_Region]&'.'&Territory&'|'

              &upper(ACCOUNT_SEGMENT)&'|'&[NCV Type]&'|'

              &[Hyperion Budget Unit]&'.'&SCBU&'|'&left(Fiscal_Period,4)&'-Q'&Right(Fiscal_Period,1)

              as [~MasterKey];

          LOAD

              *,

              Pipe,

              PNCV As [NCV Type]

          FROm

          [C:\Users\BOYPR01\Desktop\Office\PIPELINE GAP\DATA.xlsx]

          (ooxml, embedded labels, table is Data);

           

          Thanks