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 Talend Studio User Guide.
The main input table contains three columns: lname, fname and email. You want to check the entries in these columns against patterns.
- In the Repository tree view, expand where you have stored the main input schema and drop the relevant file onto the design workspace.
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.
- Drop the following components from the Palette onto the design workspace: tMultiPatternCheck and two tLogRow.
- Connect the main input component to tMultiPatternCheck using a connection.
- Connect tMultiPatternCheck to the two tLogRow components using the Matches and Non Matches connections.