I have two inputs a and b I need to do a lookup as the following OR condition a.a1 = b.b1 or a.a1=b.b2 or a.a1=b.b3, if no match in all these 3 fields, go to reject file Can I simply use one TMAP with one lookup to specify this condition to get the matched and reject? Much appreiated
I don't quite understand what you want now? The tMap example I posted should give you the records from a that don't match any field in b in one step...
Ignore my previous comment about tJavaRow; it was incorrect.
A couple of other comments about your image:
- The tReplicate multiplies your flow so it can go to more than one component. It is pointless as you've used it.
- You do not need to sort your flow to use tUniqueRow.
Alevy, Thanks for your information.
Sorry to try so many times to upload, there is some problem with my screen resolution.
Please see the above two screen, originally I did the same set up as you
The expression is as the following.
row1.a1==null || !(row1.a1.equals(row2.b1) || row1.a1.equals(row2.b2) || row1.a1.equals(row2.b3))
I have 'a' file
1,11
2,22
3,33
4,44
5,55
b file
11 ,88 ,99
66 , 22,33
77 , ,33
The output is as followings
1;11;66;22;33
1;11;77;;33
2;22;11;88;99
2;22;77;;33
3;33;11;88;99
4;44;11;88;99
4;44;66;22;33
4;44;77;;33
5;55;11;88;99
5;55;66;22;33
5;55;77;;33
11, 22, 33 should not be in the output, becasue these value can be found in one of the 3 fields b1, b2, b3 in the b file.
2) Another question regarding tReplicate component in the original screen I sent to you, I tried to drag two rows from tUnique and tReplicate into tMap2, but somehow, the system doesn't allow. If I first drag the row tUnique output into tMap2, then I can't add the output from tReplicate. The same problem if I drag the ouput of tReplicate first.
That is why I have to use another delimiter input file ponting to the same a file. Do you know why is that?
Hopefully this time I explain my situation clearly and you can help me. Thanks.
