Multi Schema invoice file, 3 record types in sequence

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?

 

 

 

Five Stars JW1
Five Stars

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

ST1.JPG

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.