Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

(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.
Tags (1)
1 Solution

Accepted Solutions

Re: how to add a field to the script?

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

2 Replies

Re: how to add a field to the script?

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

MVP
MVP

Re: how to add a field to the script?

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

Community Browser