Select value from table where value equals something

[Anonymous]

Searched but couldn't find answer. New to Talend, probably a basic question. I have a table "batch_num", that has rows containing batch numbers. The current row (current batch number) is marked with an "N" for not finished, and contains a column with the corresponding batch number "batch_id". I need to grab this batch number and insert it into tables when other data is loaded. How to accomplish? Please let me know if more information is required. A coworker suggested "select batch_id from batch_num where finished=’N’’", but I'm not sure where or how to use.

[manodwhb · Accepted solution]

@TWOF,for example your source db is mysql means you should use the above query in tMysqlInput.