Discussion Board for collaboration related to QlikView App Development.
I have two tables table A and Table B.
I have to join Table A and Table b say on column 1,
Join Condition1 : Table1.Column1 = Table2. Column1
For some records the data set wont be linked based on column1 due to different values in column1, in that case I have to use different columns,
if data doesnt match
Join Condition2: Table1.Column1 = Table2. Column4
Something like below image
Kindly suggest how to resolve this issue.
Appreciate your help in advance.
maybe do something like this:
Mapping Load Distinct
'YES' AS FLAG
From TABLE A;
Column1 as KEY
from Table A;
If(ApplyMap('MAP_TABLE',Column1,'NO')='NO',Column4,Column1) as KEY
from Table B;