Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Lookup OR condition in tMap

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
Labels (2)
30 Replies
JG6
Contributor II
Contributor II

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))