Lookup on multiple columns with or condition

veryimportantdude — Fri, 15 Nov 2024 23:09:37 GMT

I am trying to do a lookup on multiple fields with OR condition

for example.

Table 1:

name

some_string

Table 2:

code

field1

field2

field3

...

field 6

somerandomfield

I need to do a lookup from Table1's ield some_string to Table2 where it has to match with either field1 or field2 or field3.... or field 6 and get the code of the record.

Is there a Talend tool or should I write an SQL query with Union to transpose the Table2?

Any suggestions?

I hope the question is clear enough

Thank you

Re: Lookup on multiple columns with or condition

Anonymous — Fri, 04 Mar 2022 07:47:04 GMT

Hello,

Could you please elaborate your case with an example with expected output values as well?

Best regards

Sabrina

topic Lookup on multiple columns with or condition in Data Quality

Lookup on multiple columns with or condition

Re: Lookup on multiple columns with or condition