Double-click tFixedFlowInput to open its
Click the three-dot button next to Edit
schema to open the schema editor.
Click the plus button and add five rows.
Rename these rows respectively as the following: Record_ID, File, Acctname, GRP_ID and GRP_SIZE.The input data has information about group ID and group size. In real life scenario, such information can be gathered by the tMatchGroup component as shown in scenario 1. tMatchGroup groups duplicates in the input data and gives each group a group ID and a group size. These two columns are required by tRuleSurvivorship.
In the Type column, select the data types
for your columns. In this example, set the type to Integer for Record_ID and
GRP_SIZE, and set it to String for the other columns.
Make sure to set the proper data type so that you can define the validation rules without error messages.
- Click OK to validate these changes and accept the propagation when prompted by the pop-up dialog box.
- In the Mode area of the Basic settings view, select Use Inline Content (delimited file).
In the Content field, enter the input
data to be processed.
This data should correspond to the schema you have defined. In this example, the input data is as the following:
1;2;AcmeFromFile2;1;2 2;1;AcmeFromFile1;1;0 3;1;AAA;2;1 4;2;BBB;3;1 5;1; ;4;2 6;2;NotNull;4;0
- Set the row and field separators in the corresponding fields.