ETL and Data Integration tools - Modern ETL software for everyone

Hi guys,

I have a pipe delimited file to load. One field has list of values separated by commas. I need to create one record per each value in that list. But there may be multiple values like a,b,d or only one value like k in that field.

Can you advise me the best way to split the record into multiple based on the number of values coming into that field irrespective of it has a,b or c values separated by commas?

Thanks a lot,
Maria

Maria

Is there maximum number of fields you can get?

Peter

Peter

Thank for the quick response.

I can't really tell you the number can be very high

Maria

This can be easily done by using Advanced ETL Processor Un Pivot transformation.

See attached picture

Peter

Thank you Peter

I have never thought that it is going to be that simple.

Maria