topic how to add a field to the script? in QlikView

how to add a field to the script?

Tue, 07 Jul 2015 16:50:45 GMT

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);

sunny_talwar — Tue, 07 Jul 2015 16:58:43 GMT

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 — Tue, 07 Jul 2015 16:59:48 GMT

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