Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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?
