HomeForum
Welcome, Guest

Include the line number of the row from the extract
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Include the line number of the row from the extract

Include the line number of the row from the extract 10 months, 2 weeks ago #3051

  • BG
  • OFFLINE
  • Fresh Boarder
  • Posts: 6
  • Karma: 0
When writing failed records to the log file and it lists the error, is there a way to include the line number of the row from the extract that had the issue?
That way you can look at the original extract (if its like a 50k row extract) and look at the actual line that had the issue.

Sorry about all the questions but another issue that I do not see this
in the documentation.

Thanks,
B

Re: Include the line number of the row from the extract 10 months, 2 weeks ago #3052

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Hi

Connect another transformer to validator and write all failed records into the separate file.
Plus you can use reader properties object to get line/record number.

Mike
  • Page:
  • 1
Time to create page: 0.25 seconds

Testimonials

"I've been very impressed with Advanced ETL Processor. It is extremely powerful and can validate and transform practically any data set you work with."

David Gig,
Director of Information Technology

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top