topic Re: Apply Map - Value from Another Field in QlikView

Apply Map - Value from Another Field

Anonymous — Tue, 03 Oct 2017 15:50:06 GMT

IDMAPPING:

MAPPING LOAD
OLDID as ID,

NEWID

FROM A;

OLDID NEWID

1 11

2 12

ID Name

1 Apple

11 Banana

2 Orange

12 Grapes

FINALB:

LOAD

ApplyMap('IDMAPPING', ID,ID),

Name

FROM B

FinalB:

ID Name

11 Apple

11 Banana

12 Orange

12 Grapes

WANT:

FINALTABLE:

ID Name

11 Banana

12 Grapes

Is this possible?

Re: Apply Map - Value from Another Field

vishsaggi — Tue, 03 Oct 2017 15:57:28 GMT

Try this:

LOAD * INLINE [

OLDID, NEWID

1,11

2,12

];

IDMAPPING:

MAPPING LOAD

OLDID as ID,

NEWID

Resident A;

LOAD * INLINE [

ID, Name

1 , Apple

11, Banana

2 , Orange

12, Grapes

];

NoConcatenate

FINALB:

LOAD

ApplyMap('IDMAPPING', ID,ID) AS ID,

Name

Resident B;

DROP TABLE B;

Re: Apply Map - Value from Another Field

arjakumar — Tue, 03 Oct 2017 16:04:22 GMT

Hi Viswa,

I Think in apply map 3rd parameter would be the missing value not the field name.

Re: Apply Map - Value from Another Field

Anonymous — Tue, 03 Oct 2017 16:05:15 GMT

Hi Vishwarath

I tried the code below - all i added was dropping table A. As per the results the new ID has the old name.

LOAD * INLINE [

OLDID, NEWID

1,11

2,12];

IDMAPPING:

MAPPING LOAD

OLDID as ID,

NEWID

Resident A;

LOAD * INLINE [

ID, Name

1 , Apple

11, Banana

2 , Orange

12, Grapes];

NoConcatenate

FINALB:

LOAD

ApplyMap('IDMAPPING', ID,ID) AS ID,

Name

Resident B;

DROP TABLES A, B;

Want 11 to have Banana and 12 to have Grapes

Re: Apply Map - Value from Another Field

rwunderlich — Tue, 03 Oct 2017 16:06:08 GMT

I think you want to map twice -- once for the id followed by an applymap to get the name.

IDMap:

MAPPING LOAD * INLINE [

oldid, newid

1,11

2,12

]

;

InputB:

LOAD * INLINE [

ID, Name

1, Apple

11, Banana

2, Orange

12, Grapes

]

;

NameMap:

MAPPING LOAD

ID, Name

Resident InputB

;

FINALB:

NoConcatenate

LOAD

ApplyMap('IDMap', ID) as ID,

ApplyMap('NameMap', ApplyMap('IDMap', ID,ID)) as Name

Resident InputB

;

Drop TABLE InputB;

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Re: Apply Map - Value from Another Field

Anonymous — Tue, 03 Oct 2017 16:15:11 GMT

That works! Thanks Rob!!