how to map the data?

[#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

FROm

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

[sinanozdemir]

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

(ooxml, embedded labels, table is Data);

Thanks