Select value from table where value equals something

Five Stars

Select value from table where value equals something

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.


Accepted Solutions
Forteen Stars

Re: Select value from table where value equals something

@TWOF,for example your source db is mysql means you should use the above query in tMysqlInput.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

All Replies
Forteen Stars

Re: Select value from table where value equals something

@TWOF,for example your source db is mysql means you should use the above query in tMysqlInput.
Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads