topic Re: Trigger another job, when tSystem output has certain text?. in Talend Studio

Trigger another job, when tSystem output has certain text?.

Anonymous — Sat, 16 Nov 2024 03:36:45 GMT

Hello,

I want to trigger a stored procedure, when I run in tSystems an external perl script, which finishes successfully.
This is the output of the perl script in the tSystem component:

Start loading data at: 2008-04-17 10:46:23
Preparing load of data in /path/to/file/file.TXT:

Records inserted: 672
Finished loading data at: 2008-04-17 10:46:24

So I used an If-Trigger connection and I tried this:

((String)globalMap.get("tSystem_1_OUTPUT")) =="Finished loading data"

But nothing happens .
I guess you will suggest me to use regex, but I couldn't figure out how to use it.

thanks

iosman

Re: Trigger another job, when tSystem output has certain text?.

fdenis — Tue, 14 Jan 2020 09:29:58 GMT

you have to use string1.equals(string2) in java

but ((String)globalMap.get("tSystem_1_OUTPUT")) contain all the output
so you want to fount the position of your string.
https://docs.oracle.com/javase/7/docs/api/java/lang/String.html#contains(java.lang.CharSequence)

your if condition must be:
((String)globalMap.get("tSystem_1_OUTPUT")).contains("Finished loading data")

regards

Re: Trigger another job, when tSystem output has certain text?.

fdenis — Thu, 16 Jan 2020 09:37:26 GMT

can you tag it as solved or/and explain the solution.