Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

optional keys columns to be used for joining

Dear All,

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

 
 

img1.PNG

 

 

 

 

 

 

Kindly suggest how to resolve  this issue.

Appreciate your help in advance.

1 Reply
Highlighted
Partner
Partner

Hi

maybe do something like this:

MAP_TABLE:

Mapping Load Distinct

Column1,

'YES' AS FLAG

From TABLE A;

 

LOAD *,

Column1 as KEY

from Table A;

Left Join 

LOAD *,

If(ApplyMap('MAP_TABLE',Column1,'NO')='NO',Column4,Column1) as KEY

from Table B;