IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only
Back to discussions
Expand all | Collapse all

Grouping using Control Break

  • 1.  Grouping using Control Break

    Posted 07/08/08 11:18 AM

    Originally posted by: SystemAdmin


    Hi,
    I am working on NSF to XML map.(WTX 8.1) The ip NSF has the following structure:
    I have attached my sample ip here.
    My ip tree has the following structure:
    File:
    Submission(1:99999)
    R01ProcessorData
    Provider(1:99999)
    R10ProvData
    Claim(1:99999)
    R20Grp
    ---
    R91Grp
    R95ProvBatchCntrl
    R99FileControl

    I want to group the ip in such a way that evrytime a provider changes only then the HDR & TRLR ie (R10 & R95) should be repeated.
    In all other cases, claims from a single provider should be grouped under one R10 & R95 records.

    I am trying to do this grouping using Control Break Logic.The provider number is the sixth element in group R10.(its "383229575" in the
    sample ip)

    Would greatly appreciate any recommendations or help.

    Thanks in Advance!
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


Related Content