topic Re: how to map the data? in QlikView

how to map the data?

Mon, 06 Jul 2015 18:09:17 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

FROm

(ooxml, embedded labels, table is Data);

sinanozdemir — Mon, 06 Jul 2015 19:20:09 GMT

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