Multiple lookup as input of tmap with same row

[Anonymous]

All,

I try to use the same input row with multiple lookup of tmap component.
The multiple internet requests I have performed does not lead to an acceptable result.

Below are the details:

Input files:

• main

product;creator_id;modifier_id
p1;1;2
p2;2;3

• users

id;name
1;rex
2;teddy
3;ivan

expected result (first letter with upper case)

product;creator_name;modifier_name
p1;Rex;Teddy
p2;Teddy;Ivan

Screenshot of the job

And the tmap configuration

The job designer refuses to establish a new link between tReplicate_1 and tMap_1 which could solve my issue.
I know that it would be possible to use a temporary file and re-use it as a lookup but I would like to know if there is a cleaner solution.

Many thanks

Jareth

[Anonymous]

Hi Jareth,

    You can read the file once and store it into a tHashOutput for later use (please note that since the data is holding in memory in Hash, you need to provide adequate job memory according to lookup volume).

     In your existing job, you can read the data in Hash multiple times using tHashInput (clear the Hash data only in second lookup) and join it to tMap for further processing.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

[Anonymous]

Thanks for your answer,

I could not find the tHashOutput in the palette (cf. attachment). Perhaps it is not included in the version of TOS I have downloaded.

And I understand that it is not possible to have an entry in the tmap component from the same 'tReplicate' component. Is it impossible by design or is it necessary to activate an option ?

Regards,

Jareth

Annotation 2020-01-15 140535.png

[Anonymous]

Hi Jareth,

    Could you please select File -> Edit Project Properties and go to Designer area. You can select Hash components there and can add them to components which can be used.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved