How to insert data if not present in table?Infinidb
Hi all!
I have a table in the infinidb. Table not have foreign key.
My talend job have two tInputMySQL, - one main input and one Lookup component that connect to the tMap.
I use expession in the tMap, "row1.id!=row4.Master_category_value" If id not exist at the selected data then process insert data. But this expression don't work! Talend ignore this expression and beging insert duplicate data.
Ok, in the tMysqlOutput component set option in "action on data" = update or insert. But Talend create new row when and i have many duplicate rows! Does this issue cose i use table without foreign keys?
Sorry for my english. Lets see my screenshots in attachments.
What you have done in tMap is for each main row (row1) get every row from the lookup table (row4) where row1.id!=row4.Master_category_value whereas what you want, I think, is to get each main row that does not have a match in the lookup table.
You should have row1.id in the Expr.key field to the left of Master_category_value in the lookup table and change the lookup table to inner-join. Then remove the filter expression on the output table and change "Catch lookup inner join reject" to true.
Wnen i set Catch lookup inner join reject in true then 0 rows selected to the outputable..
I want create query like : select * from table a where a.id not in (select master_id from table b) and insert there rows. But table a and table b have different databases and i can't implement this query in one tMysqlInput See attachments.
hmm, it should be able to select another option, double click on the 'left outer join', there should be a button like '...', click on the button and select the option 'inner join'
Best regards
Shong
hmm, it should be able to select another option, double click on the 'left outer join', there should be a button like '...', click on the button and select the option 'inner join' Best regards Shong
No, Join Model for row4 have only 'left outer join' option..
talend open studio, 4.2.2 version
Build id: r63143-20110622-0628
