I'm an absolute beginner in Talend. I have to create a job to have to:
Task1. Delete some rows from tableNameA which correspond to certain conditions, more precisely Status1=xy and Status2 = tz. This is actually quiet simple since these conditions are included into the WHERE clause in the query:
DELETE FROM TableNameA
WHERE Status1 = xy AND Status2 = tz
The query above will delete all the rows that matches the WHERE clause, including values of a column named DeliveryId.
Task2. Drop multiple tables, said tableNameB, that contain the same DeliveryId column as tableNameA. Note that tables B are named according to the following format: "tableNameB_xyz", where xyz is the DeliveryId.
In my job I use a tFlowToIterate component linked to a tMySqlRow component in order to perform task 1, as can be seen in the attached figure.
My question is, how can I drop all the tables "tableNameB_xyz" that match the DeliveryId selected in Task1?
