ETL and Data Integration tools - Modern ETL software for everyone

Good morning,

Can you tell me if there is a way to output multiple target records from a
single source table.

Example- I have a ODBC input file which has rows of:

Client number | Name1 | Name2

I need to create two records in the output table for each or these

Row 1:
Client number | Name1

Row 2:
Client number | Name2

Currently, the only solution I've come up with is to make two passes at the
file.

Thanks
Joe

Yes it is possible

Have a look at pivot and unpivot objects

You may start from this demo

www.dbsoftlab.com/online-tutorials/advan...ivot-and-sorter.html

Mike