Multi Schema invoice file, 3 record types in sequence

Anonymous — Tue, 24 Apr 2018 13:11:08 GMT

I'm attempting to convert a input file of invoice data into a format where each invoice line is preceded by a header record and followed by a distribution record. Something like this:

20787750 WCBC41000000000DBISCHTRANSP0000000000000165

30787750 WCBC4100000000000001DBISCHTRANSP0000000000000165 OO

40787750 WCBC410000000000000100001DBISCHTRANSP0000000000000165 NP

20166168 WCBC41000000000DBISCHTRANSP00000002/0234/18

30166168 WCBC4100000000000001DBISCHTRANSP00000002/0234/18 OO

40166168 WCBC410000000000000100001DBISCHTRANSP00000002/0234/18

30166168 WCBC4100000000000003DBISCHTRANSP00000002/0234/18 OO

40166168 WCBC410000000000000100001DBISCHTRANSP00000002/0234/18

If I refer to the records as type "2", "3" and "4", it's possible to have a number of "3" and "4" types for every "2" type record.

The Talend job I have built generates the output file, but it puts a single type 4 record at the end of the type 3 records, something like this:

20787750 WCBC41000000000DBISCHTRANSP0000000000000165

30787750 WCBC4100000000000001DBISCHTRANSP0000000000000165 OO

40166168 WCBC410000000000000100001DBISCHTRANSP00000002/0234/18

but I need it to alternate the "3" and "4" types records under every "2" type.

How do I control the sequence of 3 and 4 type records?

Re: Multi Schema invoice file, 3 record types in sequence

Anonymous — Tue, 24 Apr 2018 13:12:54 GMT

topic Multi Schema invoice file, 3 record types in sequence in Talend Studio

Multi Schema invoice file, 3 record types in sequence

Re: Multi Schema invoice file, 3 record types in sequence