ETL and Data Integration tools - Modern ETL software for everyone

Good morning,

I have a requirement in VIP to export multiple records (all the same with the exception of one or 2 fields) from a single source. The source has 10 distinct names in designated fields that will be exported to single rows in the output table.


ie Input ---> Client # Name1 Name2 Name3 .....Name10

Output--->

Client# Name1
Client# Name2
Client# Name3
etc.
Client# Name10

I know I can do this with multiple passes at the source data, but is there a way to accomplish it in one pass?

thanks,
Joe

Joe

All I can suggested is to use union

select name1 from table
union all
select name2 from table

I think Advanced ETL processor would be a better option for you.
It has got pivot and unpivot objects

if you wish I cab build for you an example how it can be done in Advanced ETL Processor.

Mike