topic Re: Joining 3 input in a TMap in Talend Studio

Joining 3 input in a TMap

_AnonymousUser — Sat, 16 Nov 2024 10:44:50 GMT

Hello,
i'm new to Talend, and i have a problem.
I have 3 input in my Tmap, A,b and C.
input A contain: Id
input B:
-Id
-Operator
-Code_Alpha
input C contains:
-ID
-infoA
-infoB
-Country
-Support
The problem is:
Now, the country and support of the input C are empty, the goal is to have the table C as an output, with Country and Support filled in with the right informations.
My probleme is, there is a condition to fill these field, and i don't know how to apply it.
The condition is:
We should keep in mind that InfoA and Info B are different, and B.Id stocks infoA and InfoB
if infoA == A.ID we take operator and code_alpha from table B where b.Id = infoB and we assign operator to support and code_alpha to country
if infoB == A.ID we take operator and code_alpha from table B where b.Id = infoA and we assign operator to support and code_alpha to country
i hope i was clear in my explanation,
And Thank you for your help in advance,

Re: Joining 3 input in a TMap

Anonymous — Fri, 11 Mar 2016 13:43:26 GMT

you can split it into two flows.
1st flow , inner join the 3 tables ( infoA == A.ID we take operator and code_alpha from table B where b.Id = infoB and we assign operator to support and code_alpha to country )
2nd flow inner join the 3 tables again, (infoB == A.ID we take operator and code_alpha from table B where b.Id = infoA and we assign operator to support and code_alpha to country) and you update insert the same table.
or you store both outputs in a file ou hashoutput and you do union.
Good luck

Re: Joining 3 input in a TMap

_AnonymousUser — Fri, 11 Mar 2016 13:52:53 GMT

Actually what i forgot to mention is, that infoA should'nt be equal to A.id, the condition is:

if infoA is in the tfileInputDelimited then we take operator and code_alpha from table B where b.Id = infoB and we assign operator to support and code_alpha to country
so for each line in input c i should verify if infoA is in input A then we take operator and code_alpha from table B where b.Id = infoB and we assign operator to support and code_alpha to country