Search code examples
mysqltalend

Using Talend ETL tool, How to insert a non existing record to MySQL table from Excel Sheet?

I have an excel sheet column in which I need to insert only non existing records. Example: list of university
1. Sri Krishnadevaraya University
2. Sri Krishnadeveraya University(SKU)
3. St Jerome University
4. St.Peters University

table already have "St.Peters University" so I need to insert
1. Sri Krishnadevaraya University
2. Sri Krishnadeveraya University(SKU)
3. St Jerome University.

Solution

  • in talend you would use the components tfileinput-->tlogrow-->tmap--tlogrow-tmysqloutput. Any filter / transformations / business logic can be done in the tmap component.