topic Using tMsgBox on RunIf in Talend Studio

Using tMsgBox on RunIf

Serphentelm — Fri, 15 Nov 2024 21:37:07 GMT

Hi Team,

I've a very simple question:

I got a tDbInput that read a count(*) from a query and i want to use the TMsgBox when count(*) > 0.

so the job wuold be:

TDbInput --if --> TmsBox

where the query on Input component is just a "select count(*) from my_table where my_condition".

I think this is a pretty simple task, but I can't figure out how to retrieve the information in the if window.

can anyone help?

Thanks

Re: Using tMsgBox on RunIf

anselmopeixoto — Thu, 06 Jul 2023 13:39:04 GMT

HI @matteo marchesi

I suggest you use a tFlowToIterate in between those components to create a global variable storing the count value produced on tDBInput.

The job will become something like this:

tDBInput --row1--> tFlowToIterate --If--> tMsgBox

Considering the schema on tDBInput has a column called "count", tFlowToIterate will automatically create a global variable called "row1.count" and you can use it on your If trigger like this:

((Integer)globalMap.get("row1.count")) > 0