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!
... View more