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.  printing natural numbers:

    Posted 08/21/08 09:16 AM

    Originally posted by: malag


    How to print 1 to 100 in WTX without taking any input file?
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 2.  Re: printing natural numbers:

    Posted 08/21/08 03:16 PM

    Originally posted by: SystemAdmin


    Create a functional map like:
    Print_1-100(CLONE(Field, 100), Index($))

    The functional map rule would then be:
    =NUMBERTOTEXT(Index) /* Assuming you've named the FMap's 2nd input card, Index.

    Take a look at the function, GETANDSET. You might find it useful.

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


  • 3.  Re: printing natural numbers:

    Posted 08/21/08 04:31 PM

    Originally posted by: malag


    Jim,
    when i am creating a function map using the given logic by you,it is asking for a reference for index($) card and it is showing in yellow color .How to build the function map in that case.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: printing natural numbers:

    Posted 08/21/08 06:42 PM

    Originally posted by: SystemAdmin


    Highlight the yellowed Index object, click on the Edit button, and then complete the Card Attributes entry form by selecting a numeric object from one of your input type trees. Or you could pass the index value in the FMap as text and then select a text field, e.g., NUMBERTOTEXT(INDEX($))
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


  • 5.  Re: printing natural numbers:

    Posted 08/22/08 10:31 AM

    Originally posted by: malag


    Thanks Jim,It is working.You are a genius.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender