HomeForum
Welcome, Guest
ETL-Forum
Forum
Advanced ETL Processor

File which contains header rows and detail rows
(1 viewing) (1) Guest
Reply Topic
New Topic
  • Page:
  • 1

TOPIC: File which contains header rows and detail rows

File which contains header rows and detail rows 11 months, 1 week ago #2913

  • Ron
  • OFFLINE
  • Junior Boarder
  • Posts: 22
  • Karma: 0
I have a question.

I have a text file which contains header rows and detail rows, which can be identified by a record type code.

For each detail line I want to write out a row to SQL server, but I need it to include data from the associated header row.

Is that possible?


Ron
Reply Quote

Re: File which contains header rows and detail rows 11 months, 1 week ago #2914

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2182
  • Karma: 12
Yes it is possible.

Depending on the source file structure you can use Previous Line function or a combination of keep value and calculation transformation

There are some examples available in default repository plus you can watch out online tutorials

Peter K
Reply Quote
Reply Topic
New Topic
  • Page:
  • 1
ETL-Forum
Forum
Advanced ETL Processor
Powered by Kunena
Time to create page: 0.15 seconds

Testimonials

"Because of our relationship with DBSL, We are able to provide more complete solutions for our customers. As one of our key technology partners, DBSL is always willing to go that extra mile: adding new functionality, assisting us with support issues ... and this has been an important part of our success."

Bill Dill,
Deployment 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

Submit to Delicious Submit to Digg Submit to Facebook Submit to Google Bookmarks Submit to Stumbleupon Submit to Technorati Submit to Twitter Submit to LinkedIn
Go to top