About file merge after format conversion

Anonymous — Tue, 23 May 2017 03:48:10 GMT

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

２．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.

３． 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

Re: About file merge after format conversion

Anonymous — Wed, 14 Jun 2017 10:18:36 GMT

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

topic Re: About file merge after format conversion in Talend Studio

About file merge after format conversion

Re: About file merge after format conversion