How to do join lookup column row with lookup colunm row in tmap component?

[Anonymous]

Hello everyone,

I wanna to ask how to do join between lookup column row with lookup column row using tmap component?

when i do that join, a column user_id,methode_id, and methode_name values is null or zero...

I really hope all of your help about this for my thesis...Thanks everyone...

[jagadish_dasari · Accepted solution]

Hello,

The correct join operation in tMap is MAIN_FLOW to LOOKUP_FLOW

The join you are trying to establish (LOOKUP_FLOW to LOOKUP_FLOW) is wrong.

Work-Around: Use separate tMap where you have to join outcome of first tMap as main and other join as lookup.

Something like this: 

MAIN=>tMap1(join LOOKUP1)=get lookup-value>tMap2(join LOOKUP2)=get lookup-value=>tMap3(join LOOKUP3)=get lookup-value=>TARGET.

Thanks,

Jagadish.

[Anonymous]

Hello,

Please have a look at this online document about:TalendHelpCenter:tMap lookup models.

Best regards

Sabrina

[Anonymous]

Thanks for your clue...finally my work is done..