ETL and Data Integration tools - Modern ETL software for everyone

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?

Bob

Can you email us a sample please

Peter

The first column is the record code. I want to write out data when the record code is a 6.
But when I write out a row to the SQL table, one column needs data from the prior record code 5. That data doesn’t exist on record code 6 row.

Bob

You can do it using Advanced ETL Processor (Visual Importer was not designed to do it)

Use previous value function or keep value plus calculations

Peter