HomeForum
Welcome, Guest

Read the ‘file row’ from the source file
(1 viewing) (1) Guest
Data Warehousing and Data integration
  • Page:
  • 1

TOPIC: Read the ‘file row’ from the source file

Read the ‘file row’ from the source file 11 months, 1 week ago #2950

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Hello

I have a question

Is it possible for the Reader Parameter to read the ‘file row’ from the source file?

An example is: I have a source file with two rows of header data and ten rows of actual data.
Rows 4 and 7 will be rejected by my validator for a specified reason.
The file rows for the data loaded should be (3,5,6,8,9,10,11,12).
We have a couple of file loads that call for a file row from the source file.

Steve

Re: Read the ‘file row’ from the source file 11 months, 1 week ago #2951

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
Are you trying to load header data into some field or just skip it?

Peter

Re: Read the ‘file row’ from the source file 11 months, 1 week ago #2952

  • SteveK
  • OFFLINE
  • Junior Boarder
  • Posts: 32
  • Karma: 0
Peter.

We are trying to skip the header data.

Thanks
Steve

Re: Read the ‘file row’ from the source file 11 months, 1 week ago #2953

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2183
  • Karma: 12
well Set lines to skip what ever you want and this should do the trick
Attachments:
  • Page:
  • 1
Time to create page: 0.17 seconds

Testimonials

"We used Advanced ETL Processor to give us more flexibility with business automation. And better yet, we always felt that the DBSL support team is a true partner in every sense of the word, assisting us when we needed help"

Carlos Tantis,
Marketing Manager

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