topic Re: Using globalMaP after onsubjobok in Talend Studio

Using globalMaP after onsubjobok

since_1995 — Fri, 15 Nov 2024 22:38:11 GMT

Hi all,

Is it possible to use the

((String)globalMap.get("row1.column1")) in the second job

tdbinput --row1--->trest---->tfiledelimited

tfileinputdelimited---textractjsonfield---tmap2--->idbout

here i want to use the outputput from

tdbinput i,e ((String)globalMap.get("row1.column1")) in tmap2

is that possible?Is there a way to call that.

Re: Using globalMaP after onsubjobok

Daniel044 — Mon, 22 Aug 2022 05:38:37 GMT

I also faced same issue but now it solved for me. Thank you for the help.

Re: Using globalMaP after onsubjobok

since_1995 — Wed, 24 Aug 2022 18:39:48 GMT

Can you please share the solution

Re: Using globalMaP after onsubjobok

Anonymous — Wed, 24 Aug 2022 22:58:10 GMT

You need to explain what you are wanting to do? If your tDBInput produces 1 million rows, they will have all been processed by the end of the 1st SubJob. So the value of ((String)globalMap.get("row1.column1")) will likely be useless. The OnSubJobOK only fires at the end of the SubJob. You can make use of globalMap values between SubJobs, but you need to understand that (in the way you have this designed) SubJob 1 will be complete before SubJob 2 starts. So either you need to save all the values for column1 OR you need to rearrange your job so that whatever is happening in SubJob 2 happens once for every row processed in SubJob 1.

Re: Using globalMaP after onsubjobok

since_1995 — Thu, 25 Aug 2022 03:12:02 GMT

Yes there are 5 columns coming out of tdbinput, in which I will be using only one column in the first job so can I store rest of the column values globally and can call it at my subjob 2 and pass it to dboutput?

I used tjavarow after tdbinput1 and stored the columns using context but it is passing only the last value of these columns to all the records in my tmap2

Re: Using globalMaP after onsubjobok

since_1995 — Thu, 25 Aug 2022 03:12:48 GMT

So I need to save all values for column1