topic Re: Join datas thanks to id get from globalmap in Talend Studio

Join datas thanks to id get from globalmap

ShZ — Tue, 12 Dec 2023 11:58:34 GMT

Hi everyone,

I am facing an issue as I try to join some datas, let me give ou some informations about my job.

I am getting a list of objects thanks to a REST API call. Each object has a validation date which I can get with another REST API call.

On the top (number 1) you can see the first part of my job which is getting all objects and which is working fine.

On the bottom (number 2) you can see the second part of my job which is a lookup and calls the REST API using an id as parameter to get the validation date. This id needs to be used to join to the datas coming from the first part of my job (number 1). As this id isn't part of the response sent by the REST API which sends me the validation date, I am trying to get my id back in the tMap (number 3) on my screenshot by using : String.valueOf(globalMap.get("row10.reportId"))

Afterwards, I try to link the validation date I get to each object I get in my tMap (number 4) doing like this :

According to my tLogs, I have datas who should match but it seems that nothing matches in my tMap (numbe r4) output.

Any suggestion ?

Thanks a lot for your help.

Re: Join datas thanks to id get from globalmap

Anonymous — Thu, 14 Dec 2023 08:26:44 GMT

Add a tUnite component after tMap_3 to merge all the records (ReportId and EventDate) before you do the join, please try and let me know if it works.

Regards

Shong

Re: Join datas thanks to id get from globalmap

ShZ — Thu, 14 Dec 2023 09:57:28 GMT

Hi shong,

Thanks a lot, it works.

For my understanding, and as I still am a beginner with Talend, what is the tUnite goal ? In my case, is it doing the join between my ReportId and my EventDate as I get my ReportId from a global map ?

Re: Join datas thanks to id get from globalmap

Anonymous — Fri, 15 Dec 2023 00:47:18 GMT

You are using tFowToIterate to iterate each ID in source file, tUnite merge all the records as lookup table, without tUnite, only the last record are output as lookup table for join.