About this task
The input data contain seven columns: lname, fname, middle_name, address, city, state_province and postal_code. The data have problems such as duplication, names spelled differently or wrongly, different information for the same customer.
- Double-click the tFixedFlowInput component to display its Basic settings view.
- Select Built-in and click the […] button next to Edit Schema.
- Define the seven columns and click OK.
- Select Use Inline Content(delimited file).
- Fill in the Row Separator and Field Separator fields.
- Enter the input data in the Content field.