how to add a field to the script?

[#1]

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

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

[sunny_talwar · Accepted solution]

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

(ooxml, embedded labels, table is Data);

[maxgro]

'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],