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
