How to pass data from one subjob to another subjob?

[HoS1]

Hi,

i need some help with my flow (see attached screenshot). I'd like to store emails in database tables. I've got one table for the emails and another for the attachments (as blobs). What i like to do is to link the blob-table to the email-table with the MessageID out of the tFileInputMail component. But it's always empty in the blob-table, regardless, what i try to do in tMap2 e.g.: ((String)globalMap.get("row1.MessageID"))

In tMap1, i can successfully use data from row2 like

((String)globalMap.get("row2.Account")), so that i now in the email-table (tDBOutput_1) from wich account the email was fetched.

I'm sure that i'm missing something, but i haven't got a clue.

If someone could help me please, it would be great.

Kind regards

Holger

[Anonymous · Accepted solution]

Hello Holger,

Maybe you can design the job like:

1. define a job context variable messageId
2. add one tJavaRow component after tMap1 to save the MessageID to context variable like: context.messageId = input_row.MessageID;

it's also needed to setup other input fields here like: output_row.xxx = input_row.xxx

3 you can use the context.messageId in tMap2 output row directly

[HoS1]

Hello,

that worked fine. Thank you very much.

Kind regards