2 Replies Latest reply: Jul 7, 2015 1:00 PM by Massimo Grossi RSS

    how to add a field to the script?

      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,

      'PNCV' AS [NCV_Type]

      FROm

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

      (ooxml, embedded labels, table is Data);

       

       

      • 'PNCV' AS [NCV_Type] this is the field I want to add to the script,
      • and then I want that to be added in the master key
      • beside [Hyperion Budget Unit] in the same manner
      • how can I achieve this?
      • Thanks in advance.
        • Re: how to add a field to the script?
          Sunny Talwar

          This may be:

           

          DATATEMP:

          LOAD

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

          upper(ACCOUNT_SEGMENT)&'|'&

          [Hyperion Budget Unit]&'.'&'PNCV'&'.'&SCBU&'|'&

          Left(Fiscal_Period,4)&'.'&

          'Q' & right(Fiscal_Period, 1)

          as [~MasterKey],

          Pipe,

          'PNCV' AS [NCV_Type]

          FROm

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

          (ooxml, embedded labels, table is Data);

          • Re: how to add a field to the script?
            Massimo Grossi
            'PNCV' AS [NCV_Type] this is the field I want to add to the script,

             

            'PNCV' is a constant

            you have already added a field with the constant PNCV

             

            and then I want that to be added in the master key

            beside [Hyperion Budget Unit] in the same manner

            maybe this?

            [Hyperion Budget Unit] & '.' & 'PNCV' &'.'&SCBU&'|'&

            Left(Fiscal_Period,4)&'.'&

            'Q' & right(Fiscal_Period, 1)

            as [~MasterKey],