How to delete existing data from MySQL Based On New TFileInput

[Anonymous]

I want to create a flow, before inserting datasource(csv/xls), i want delete record in existing database MySQL based on month of column 'period' from datasource(csv/xls). The data type of column period is "yyyyMM".

[Anonymous]

Hi
Read the period column with string type from the input file and pass it to tMysqlRow as parameter for deleting data, eg:
tfileinputDelimited-row1-tFlowToiterate--iterate--tMysqlRow

on tMysqlRow:
"delete from tableName where period>='"+(String)globalMap.get("row1.period")+"'"

Regards
Shong