Lookup on multiple columns with or condition

[veryimportantdude]

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

for example.

Table 1:

id

name

some_string

Table 2:

id

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

[Anonymous]

Hello,

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

Best regards

Sabrina