I want to apply 2 joins in a tMap component. first one is inner join and second one is left outer join. However i am unable to do so. Someone suggested me to use tJoin reject for left outer join. However, logically speaking rejected of inner join is everything that isn't inner join, which is combination of left outer join and right outer join. Can anyone help?
Even more confused. Sorry, can you suggest what you meant by "You could do a left join on both fields and include the key value from the lookup feed in the output, then filter records where the inner join lookup key is null."? New answer is somewhat different from original answer. I got a feeling that your original comment has potential. Thanks!
Use a tMap to join your main flow to your lookup flow. Join on both key columns, and set the join type to Left Outer Join. Add a field to your output schema containing the key from the lookup flow that you wanted to be an inner join. Any records generated where the lookup key is null you want to filter out. You can filter those records a number of ways. A tFilterRow component is an obvious choice, but you can also add an expression filter to your tMap output.
If this is still confusing, you should probably attach some screenshots of your job and your tMap configuration so we can give more specific advice.
