Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to map the data?

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?
1 Reply
sinanozdemir
Specialist III
Specialist III

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