Five Stars

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

Hello everyone,

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

 

20171222_174617.jpg20171222_174720.jpg20171222_174836.jpg

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...

1 ACCEPTED SOLUTION

Accepted Solutions
Six Stars

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

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.

3 REPLIES
Six Stars

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

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.

Moderator

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

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

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

Thanks for your clue...finally my work is done.. Smiley Very Happy