topic Apply map to fetch few fields. in QlikView

Apply map to fetch few fields.

Wed, 06 Jan 2016 14:21:14 GMT

I have a scenario where Table A has few missing 'check reason' values for few employees. I have to get the Review from Table B and get in into 'check reason' of Table A.

Table A:

employee#	check reason
123798	REP
324523	REP
636456
425467	GRT
678568
585333	REP

Table B:

employee#	Review
636456	GRT
678568	GRT

I was looking forward to resolve this issue using 'Apply Map' functionality as my scenario requires it.

kindly advice on the way to solve the issue.

Re: Apply map to fetch few fields.

sunny_talwar — Wed, 06 Jan 2016 15:04:11 GMT

This:

MappingTable:

Mapping

LOAD employee#,

Review

FROM

[https://community.qlik.com/thread/198583]

(html, codepage is 1252, embedded labels, table is @2);

Table:

LOAD employee#,

If(Len(Trim([check reason])) = 0, ApplyMap('MappingTable', employee#), [check reason]) as [check reason]

FROM

[https://community.qlik.com/thread/198583]

(html, codepage is 1252, embedded labels, table is @1);