Please let me know, implement the following requirements about file merge by DataIntegeration.
1. After layout conversion The layout is divided into several sections as below.
Conversion source Destination section
Columns 1 to 5 → TOP part
Columns 6 to 10 → Common part
Columns 11 to 20 → Specification part
Columns 21 to 30 → Individual information part
Columns 31 to 35 → END part
Actually, you can use tDenormalize component to merge multiple columns into one.
If your need differs or if you need more details, please supply sample input and output.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema