Lookup Functionality in tMap Component

Anonymous — Thu, 31 Mar 2016 07:08:51 GMT

Hi,
Does anyone tried lookup function with multiple condition in tMap?

Input ------ tMap ------ Output
|
Lookup Input
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.

Example:

Input Data
|   field1   |
| A |
| B |
| C |
| D |

Lookup Data
|   colA   |   colB   |   colC |
| A | B | output1 |
| E |   G | output2 |
| D |   A | output3 |
| F |   C | output4 |

Expected Output
field1 | colC
A     | output1
B     | output1
C     | output4
D     | output3

Re: Lookup Functionality in tMap Component

Anonymous — Fri, 01 Apr 2016 02:09:44 GMT

Hi

No OR logic on the lookup feature, you need to do the join two times for each filed, and then merge the result. eg:
input1--main--Map--out1--tHashOutput1
|
lookup(colA)
|
onsubjobok
|
input1--main--Map--out1--tHashOutput2
|
lookup(colB)
|
onsubjobok
|
tHashInput1--main--map--out1....
|
lookup
|
thashInput2

thashInput1: read data from thashOutput1
thashInput2: read data from thashOutput2

Regards
Shong

topic Re: Lookup Functionality in tMap Component in Talend Studio

Lookup Functionality in tMap Component

Re: Lookup Functionality in tMap Component