IBM Sterling Transformation Extender

Sterling Transformation Extender

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


#Sterling
#Supplychain
 View Only
  • 1.  How to Re-Group Data using WTX?

    Posted 03/21/16 10:44 PM

    Originally posted by: johnxp


    Hi Anyone can help on below the scenarios?

    I have the input like the following:

    Header1

    Detail1

    Detail2

    Detail3

    ...

    Header1

    Detail4

    Detail5

    Detail6

    ...

    Header2

    Detail7

    Detail8

    Detail9

    ...

    I want the output like this:

    Header1

    Detail1

    Detail2

    Detail3

    Detail4

    Detail5

    Detail6

    ...

    Header2

    Detail7

    Detail8

    Detail9

    ...

    How can I achieve this?

    Thanks.

     


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: How to Re-Group Data using WTX?

    Posted 03/22/16 04:45 PM

    Originally posted by: DeM0n


    Use Control Break Logic......Attaching the sample map, trees and test files....

    merge_latest.mtt is the input tree and mereg_out.mtt is the output tree.....


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)

    mms
    merge.mms   1 KB 1 version
    txt
    input.txt   120 B 1 version
    mtt
    mereg_out.mtt   6 KB 1 version
    mtt
    merge_latest.mtt   6 KB 1 version


  • 3.  Re: How to Re-Group Data using WTX?

    Posted 03/22/16 11:29 PM

    Originally posted by: johnxp


    Sorry, which version are you using to develop the typetree?

    I am not able to open it in 8.3.


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: How to Re-Group Data using WTX?

    Posted 03/23/16 01:01 AM

    Originally posted by: DeM0n


    I used 8.4 to create the map and type tree.....you may find the similar discussion in the forums....Paul Brett replied to someone with similar problem....I could not find it...I'll paste the link here once i find it....Its an old discussion so I assume those trees and maps should work in 8.3....


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 5.  Re: How to Re-Group Data using WTX?

    Posted 03/23/16 02:52 AM
      |   view attached

    Originally posted by: DeM0n


    see the attached example....I hope this works in 8.3...let me know how it goes....


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender

    Attachment(s)

    zip
    CtrlBreakSum.zip   3 KB 1 version


  • 6.  Re: How to Re-Group Data using WTX?

    Posted 03/23/16 04:25 AM


  • 7.  Re: How to Re-Group Data using WTX?