Need to Perform Not Equal Join

rajudx · Post by **rajudx** » Fri Jun 03, 2011 12:48 pm

Hi,

We need to perform not equal condtion on two key cloumns.

i.e
a
----
Custno cusname
10,Jack
20.Mat
30,Salole

b
-----
custno,custname
50,Richard
30,kat
20,Mat
60,Kim

I need below output...unmatched records
50,richard
60,Kim
30,Kat

I tied to use chane capture stage and it's working but some warnnings "before" "outrec" are coming.Is there any other way we can achive above logic

Thanks,
Nag

chulett · Post by **chulett** » Fri Jun 03, 2011 1:04 pm

Not seeing any evidence that this is anything related to a web service, I moved the post here.

rajudx · Post by **rajudx** » Fri Jun 03, 2011 1:07 pm

Sorry this issue is related with PX only.We need to genarate unamtched recods fom two tables into one file based on some key columns.

jwiles · Post by **jwiles** » Fri Jun 03, 2011 3:03 pm

If you need to capture records from either table that are unmatched, one way to accomplish this is with a full outer join followed by a filter or transformer to capture and output unmatched records. Add a "flag" column (such as an integer 1) to each table's data prior to the join and check the flags after the join. Your conditions will be:

LeftFlag & RightFlag
1 & 1: The records matched
1 & 0 (or null): The left record didn't match...write it out
0 (or null) & 1: The right record didn't match---write it out

Regards,

pandeesh · Post by **pandeesh** » Fri Jun 03, 2011 9:44 pm

'james wiles' solution is working.

ray.wurlod · Post by **ray.wurlod** » Sat Jun 04, 2011 2:17 am

Then the original poster can mark your thread as Resolved using the green button at the top.