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.
Solved! Go to Solution.
Watch the recorded webinar!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.