Lookup OR condition in tMap

[Anonymous]

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

[JG6]

Hi Team,

I need to implement this talend .. this is currently written in abinitio.Please help urgentlyy

(is_defined(lookup("Lookup_File", ((decimal("\307"))re_index(id, "[a-zA-Z]+") - 1),string_substring(, (decimal("\307"))re_index(id, "[a-zA-Z]+") , string_length(id))).name))