About file merge after format conversion

Highlighted
Five Stars

About file merge after format conversion

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

2.Summarize the above with different keys.
   Summary at detail section columns 12, 15
   Summary with individual information section columns 22, 23, 24
      Assumptions that other sections are summarized in all items and become one line.
 
3.Merge and output the file, but the following merge method will be used.
  Rather than making TOP ~ END a record of one line, it becomes as follows.
    TOP section 1st line
      Common part 2 line
              Specifications 3 to N
              Individual information part N + 1 row to M row
              END part M + 1 line
Moderator

Re: About file merge after format conversion

Hi,

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.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now