Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I also faced same issue but now it solved for me. Thank you for the help.
Can you please share the solution
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.
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
So I need to save all values for column1