Apply map to fetch few fields.

[#1]

Hi

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.

[sunny_talwar · Accepted solution]

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);