How to use tMysqlOutput with condition

Anonymous — Thu, 06 Dec 2018 04:26:47 GMT

Hi all,

I'm a newbie in Talend and I have an issue with tMysqlOutput component as following:

My case:

1. Select data from table A in database.

2. Loop each record in step 1 and get ID as condition for select data in table B.

3. If step 2 return no record then use data from step 1 insert into table C.

My flow:

1. tMysqlInput -> Select data from table A

2. tMap -> Get data from tMysqlInput

3. tJavaRow -> Set ID to global variable

4. tMysqlInput -> Count number of record from table B by ID (global variable)

5. tJavaRow -> Set result count to global variable.

6. tMysqlOutput -> From tJavaRow, I want to add trigger "Run if" when number of record greater than 0 but it's not working. (At this component, I want to get data from table A for insert into table C)

Please give me a solution.

Thanks!

Re: How to use tMysqlOutput with condition

Anonymous — Wed, 26 Dec 2018 09:12:35 GMT

Hello,

tMysqlOutput can't accept a trigger connector, it must be a input flow, so you can't link a runIf to tMysqlOutput.

Please have a look at tMySqlRow component which executes the stated SQL query on the specified MySQL database or you can use a tFixedFlowInput to lead to tMysqlOutput.

Best regards

Sabrina

topic How to use tMysqlOutput with condition in Talend Studio

How to use tMysqlOutput with condition

Re: How to use tMysqlOutput with condition