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.  Reverse the map

    Posted 08/26/10 06:14 AM

    Originally posted by: tj.barry


    so I used the any2xml tool to convert a pipe delimited mtt to an xml.mtt and .xsd, it also did all the mappings for me as well. The mapping quite extensive, does anyone know if there is a way to reverse it without manually mapping all the xml back to the original format?
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 2.  Re: Reverse the map

    Posted 09/02/10 10:12 AM

    Originally posted by: SystemAdmin


    I wasn't aware of the Any-2-XML tool before - but it sounds like it does one way conversion only. This makes sense as WTX can't generate a tree for which it doesn't know the format (i.e. is the structure fixed length, CSV, pipe delimited?).

    you could try swapping the input and output cards and then using the REFORMAT function though.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 3.  Re: Reverse the map

    Posted 09/02/10 12:23 PM

    Originally posted by: tj.barry


    Thanks, did exactly that about a week ago...jsut was very time consuming. I though mayeb it could use the same rules it used to convert it from the .mtt to .xsd only reversed it would work. Thanks though.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender