Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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
sunny_talwar

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