IBM Sterling Transformation Extender

 View Only
Expand all | Collapse all

How to send multiple records in a file as a single call to RUN child map

  • 1.  How to send multiple records in a file as a single call to RUN child map

    Posted Sun January 14, 2024 02:41 AM

    Hi,

    I have the below data where 000 & 002 are header and trailer record and 001 is the detail record.

    1234 in the detail record is the sequence number,so based on the unique sequence number i need to pass the data to child map.

    Since there are 2 unique sequence number in the below data so the child map supposed to be called twice with the matching detail record.

    000

    0011234Test

    0011234Test1

    0011234Test2

    0011233Tess

    0011233Tess

    002

    1st call-parent map should send the below records to child map

    0011234Test

    0011234Test1

    0011234Test2

    2nd call-parent map should send the below records to child map

    0011233Tess

    0011233Tess

    Please suggest if there is any way to achieve it.

    Thanks

    Santanu



    ------------------------------
    Santanu Baral
    ------------------------------


  • 2.  RE: How to send multiple records in a file as a single call to RUN child map

    Posted Tue January 16, 2024 12:54 PM

    What a great question! Yes, ITX has ways to do this type of grouping. The most popular way to do this is by using control-break logic. You are in luck as Paul Brett has done a nice video on the topic which you can find here: Using Control-Break Logic to Split data in ITX (youtube.com)

    He has also posted an example to the ITX community which you can find here: ITX - split file using control-break logic | B2B Integration (ibm.com)



    ------------------------------
    Stephanie Fetzer
    ------------------------------

    Original Message