Using PowerExchange to Validate and Extract Data in Flat Files

Using PowerExchange to Validate and Extract Data in Flat Files

Option 1. Skip Rows with Errors

Option 1. Skip Rows with Errors

  1. Go to the Data Map Properties dialog box and open the Data Checking tab.
  2. Select
    Skip row and write log file msg
    in the event of record-mapping errors
  3. Select
    Skip row and write log file msg
    in the event of incorrect field data.
  4. Enable field types.
  5. Click
    OK
    to validate.
    A list of records containing the correct data that match the datatype appear. Records with bad data or data mapping errors are omitted.

0 COMMENTS

We’d like to hear from you!