Does anyone tried lookup function with multiple condition in tMap?
Input ------ tMap ------ Output
Scenario is I have 1 field in the Input and 3 fields in the Lookup. The condition should be:
~ if input field is equal to first field in Lookup, output the third field
~ else if input field is equal to second field in Lookup, output the third field
~ else, output null
Basically, I want to have OR operation inside the tMap. If anyone knows how to do this, I gladly appreciate it. Thanks in advance.
| field1 |
| A |
| B |
| C |
| D |
| colA | colB | colC |
| A | B | output1 |
| E | G | output2 |
| D | A | output3 |
| F | C | output4 |
field1 | colC
A | output1
B | output1
C | output4
D | output3
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables