Discussion Board for collaboration related to QlikView App Development.
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.
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.
(html, codepage is 1252, embedded labels, table is @2);
If(Len(Trim([check reason])) = 0, ApplyMap('MappingTable', employee#), [check reason]) as [check reason]
(html, codepage is 1252, embedded labels, table is @1);
View solution in original post