×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Cannot change joiner condition operator

Cannot change joiner condition operator

Cannot change joiner condition operator

(OP)
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.

RE: Cannot change joiner condition operator

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
 

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close