Cannot change joiner condition operator

[BillLumbergh]

I'm joining 2 tables, A and B, as described below

Table A
title_id
effective_fiscal_yr
end_fiscal_yr

Table B
title_id
fiscal_yr

So Table A contains a year range, whereas table B contains specific years. So I want to set up joiner conditions as:

a.title_id = b.title_id
and a.effective_fiscal_yr <= b.fiscal_yr
and a.end_fiscal_yr >= b.fiscal_yr

In the joiner, on the condition tab, I've added the 3 conditions. However, the operator is always "=" and it does not seem to be editable. I know on other transformations such as lookups, the operator is a dropdown that would let me select <=, >=, !=, >, <, or =. This seems like a pretty standard thing to need to do. Anyone know why I cannot do this?

Thank you.

 

[blom0344]

Presuming this is a homogeneous join, I would suggest defining this 'complex' join in the source qualifier which gives much more freedom in this respect..

Ties Blom