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)
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.
