Drop the following components: a tFileInputDelimited, a tSchemaComplianceCheck, and two tLogRow components from the Palette to the design workspace.
Connect the tFileInputDelimited component
to the tSchemaComplianceCheck component
using a Row > Main connection.
Connect the tSchemaComplianceCheck
component to the first tLogRow component
using a Row > Main connection. This
output flow will gather the valid data.
Connect the tSchemaComplianceCheck
component to the second tLogRow component
using a Row > Rejects connection. This
second output flow will gather the non-compliant data. It passes two
additional columns to the next component: ErrorCode and
ErrorMessage. These two read-only columns provide
information about the rejected data to ease error handling and
troubleshooting if needed.
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 – please let us know!