Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Apply map to fetch few fields.

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
123798REP
324523REP
636456
425467GRT
678568
585333REP

Table B:

employee#Review
636456GRT
678568GRT

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.

1 Solution

Accepted Solutions
Highlighted

Re: Apply map to fetch few fields.

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


Capture.PNG

View solution in original post

1 Reply
Highlighted

Re: Apply map to fetch few fields.

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


Capture.PNG

View solution in original post