Skip to main content Skip to complementary content

Setting up the Job

In this scenario, you have already stored the main input schema in the Repository. For more information about storing schema metadata in the Repository, see Managing metadata in Talend Studio.

The main input table contains three columns: lname, fname, and email. You want to check the entries in these columns against patterns.

Procedure

  1. In the Repository tree view, expand Metadata > DB Connections where you have stored the main input schema and drop the relevant file onto the design workspace.
  2. From the Components dialog box, select the tMysqlInput component and click OK to drop it onto the workspace.

    The input table used in this scenario is called customer. It holds several columns including the three columns against which we want to do a pattern check.

  3. Drop the following components from the Palette onto the design workspace: tMultiPatternCheck and two tLogRow.
  4. Connect the main input component to tMultiPatternCheck using a Row > Main connection.
  5. Connect tMultiPatternCheck to the two tLogRow components using the Matches and Non Matches connections.

Results

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here