Not equal to condition in lookup

[kumar444]

I need to implement the below condition in lookup or outside of lookup.
Assume 'a' and 'b' as two tables.

a.casenum<>b.casenum and
a.regno<>b.regno


In the above case, I also need to know two different scenarios below.

1) Output columns ---> a.casenum and a.regno

2) Output columns ---> b.casenum and b.regno


Any suggestions would be appreciated.

Thanks.

[SURA]

I am not sure about "Outside of lookup"

But you can use a Full outer in join stage (source is left) and in the Transformer you can play with your conditions.

DS User

[kumar444]

Thanks Sura.

Did you mean to say-----

using full outer join in join stage
and filter where b.casenum and b.regno are null in transformer stage.
This is good idea.

How about in lookup?

[SURA]

As far as i know, by default Lookup will work like inner join. Still you can do it with Lookup by giving different name to any one of the metadata , taken out from the reject link and then you can play.

[ray.wurlod]

Default Lookup will work like left outer join (using Continue rule) or inner join (using Drop rule). It can not perform full outer join.

[kumar444]

Thanks Ray and Sura.

I have used two methods.

1) lookup (Reject option)

2) Outer join and filter


What do i do with main stream coming out of the lookup ? I have no use with it. Can i send it to copy stage as a target ?

[jwiles]

You could do that, as well as send all records to the main output and filter them similar to the way you've done the join. Either method should work.

Regards,

[kumar444]

Thanks much Jwiles.