Hi,
I want to reject the data using join stage..... I want to reject the data which is not having the match ....can you please guide me how to do that ??
how to reject data using the join stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
Re: how to reject data using the join stage
developeretl wrote:Hi,
I want to reject the data using join stage..... I want to reject the data which is not having the match ....can you please guide me how to do that ??
By using join stage you can't reject the which is unmatching to your join condition. In that case after join stage you should use filter or transformer stages.
OR
You can go for Lookup stage or Merge stage.
Do a left join and bring in the key columns from the RIGHT table/source.
Set up a transformer or filter after the join and send data where the RIGHT table/source columns are NULL down the reject link. These will be the rows that did not match to the RIGHT table/source
I think i have it right... or is it left?![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)
Set up a transformer or filter after the join and send data where the RIGHT table/source columns are NULL down the reject link. These will be the rows that did not match to the RIGHT table/source
I think i have it right... or is it left?
![Rolling Eyes :roll:](./images/smilies/icon_rolleyes.gif)