Select value from table where value equals something

Anonymous — Thu, 26 Apr 2018 23:56:42 GMT

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.

Re: Select value from table where value equals something

manodwhb — Fri, 27 Apr 2018 02:19:14 GMT

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

topic Select value from table where value equals something in Talend Studio

Select value from table where value equals something

Re: Select value from table where value equals something