Skip to main content Skip to complementary content

Reading input and lookup data and creating joins on related columns

The two tFileInputDelimited components read from the csv files input data about international customers and lookup data about stewards' emails and countries. The tMap component combines rows from the country columns in the input and lookup data.

If there are customers whose countries do not match any record in the lookup file, the Job writes the tasks in the campaign and leaves them unassigned.

Procedure

  1. Double-click each of the tFileInputDelimited components to open its Basic settings view.
  2. Define the schema which corresponds to the input file structure in the first component and the schema of the lookup file in the second component.
  3. Set the row and field separators in the corresponding fields and the header and footer, if any.
  4. Double-click tMap to open its editor.
  5. Map the input data flow to the output flow in the loadtasks table.
    For further information about tMap, see tMap Standard properties.
  6. To create the join to the lookup data, drop the country column from the main flow onto the same column of the lookup flow.
  7. Map the steward column from the lookup flow to the same column in the loadtasks table.
  8. Click OK to close the editor.

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 – let us know how we can improve!

Leave your feedback here