ETL and Data Integration tools - Modern ETL software for everyone

Dear support

I have the text file which generated by a system that makes use of custom fields for contact information. There may be up to 10 contacts' information in these custom columns so I need to determine which fields are associated to which contacts and then generate a new row for each.

Example:
RowID C1F1 C1F2 C1F3 C2F1 C2F2 C2F3 ...etc
12345 Mike Smith 23 Jayne Green 43
12346 Kelly Watson 50 Michael Abraham 25

So this flat format needs to look like the below format:

RowID GeneratedID F1 F2 F3
12345 123451 Mike Smith 23
12345 123452 Jayne Green 43
12346 123461 Kelly Watson 50
12346 123462 Michael Abraham 25

Is this possible with any of your ETL tools?

Any help is appreciated!

Adagio

Adagio

Advanced ETL processor can do whant you need by using UnPivot data transformation object.

Have a look at our online tutorials and documentation

You will find all necessary documentation here

John