topic Re: How can I get a boolean value from a child and test it to start next child job in Talend Studio

How can I get a boolean value from a child and test it to start next child job

android1686764069 — Fri, 15 Nov 2024 21:20:14 GMT

Hello

I have 2 children job in a my parent job

childA et childB

child A returns a boolean value

Then in parent job, i have someting like this:

How can i get the boolean value from child A and test if in the run if row?

Re: How can I get a boolean value from a child and test it to start next child job

act — Fri, 13 Oct 2023 16:03:10 GMT

Hello,

In the parentJob, in the tRunJob component, click on the button " copy Child Job Schema" .

As I understand your case, the schema of the tBufferOutput_1 in childA must be only one colum of boolean type.

"copy Child Job Schema" will create a schema in The tRunJob, same as the schema of the tBufferOutput_1 in childA (i.e. one column of boolean type)

At runtime, the flow from the tBufferOutput in ChildA can then be caught in the parent job, with a main connexion out of the tRunJob ChildA

Then you could for instance put the values the in the globalMap (with tFlowToIterate or tSetGlobalVar or tJavaRow...) and test it in the RunIf connexion -> ChildB.

You could of course, send several values (more columns) and several lines, depending of what data you send to tBufferOutput

Anne Céline

Re: How can I get a boolean value from a child and test it to start next child job

android1686764069 — Sat, 14 Oct 2023 15:51:28 GMT

Yes in my case, childA output is only a single value, so it's one column of boolean type in tbufferoutput

So in my parent job, between childA en childB I need to add a component such as tSetGlobalVar. I'll try monday. thank you

Re: How can I get a boolean value from a child and test it to start next child job

Anonymous — Sat, 14 Oct 2023 17:42:35 GMT

After you return the value from child job, you need to assign it to a context variable or global variable for used later,

eg:

tRunJob1--main--tJavaRow--runIf--tRunJob2

on tJavaRow:

context.varName=input_row.columnName;

Then, you can use the context variable directly as the condition of runIf connector.