Five Stars JW1
Five Stars

Multi Schema invoice file, 3 record types in sequence

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

30787750     WCBC4100000000000001DBISCHTRANSP0000000000000165      OO

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?

 

 

 

1 REPLY
Five Stars JW1
Five Stars

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

ST1.JPG