Procedure
-
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.
The Components dialog box displays with the corresponding component selected by default.
-
Click OK to drop the
tMysqlInput
component onto the workspace.
The input table used in this scenario is called translation. It holds several columns including the translation column that holds the English words we want to stem.
- Drop the following components from the Palette onto the design workspace: tNormalize, tFilterRow, tStem, tAggregateRow and tFileOutputExcel.
-
Connect the component together using the Main links with the
exception of the tFilterRow - tStem connection that should use a
Filter
link.