optional keys columns to be used for joining

[DeeptiRao]

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

Kindly suggest how to resolve  this issue.

Appreciate your help in advance.

[StarinieriG]

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;