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.  Temporary output cards in Functional map

    Posted 06/12/18 08:37 AM

    Originally posted by: uvaiseodam


    Hi,

    I have a requirement of code re usability. Please help me in achieving it. PFA which contains input and output. My aim is t reuse the code in functional map.

     

    Thanks 

    Uvaise Ahmed


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


  • 2.  Re: Temporary output cards in Functional map

    Posted 06/13/18 03:25 AM
      |   view attached

    Originally posted by: PaulBrett


    Here is an example map.  I do not understand how this helps with code re-usability, or why you would need 'scratch' output cards in a functional map.

    Thank you.

    Paul

    Follow me on Twitter


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

    Attachment(s)

    zip
    Example.zip   15 KB 1 version


  • 3.  Re: Temporary output cards in Functional map

    Posted 06/13/18 05:14 AM

    Originally posted by: uvaiseodam


    Thanks Paul. I have few questions.

    1. I tried to use the Total variable to calculate TotalDiiference but I couldn't drag and drop it in the rule. How did you use the Total variable of the output to calculate TotalDifference?

    2. Total = Mathematics+Science+History+Language; TotalDifference = PreviousTotal - (Mathematics+Science+History+Language). Since I couldn't use Total variable to calculate TotalDifference , I used all the variables again to get Total and then subtracted with PreviousTotal . Is there way that  can we create a temporary output card in functional map, calculate Total and store the output. Use the stored value wherever you want in the actual output of the functional map? 

    3. If we go with your approach as per your Example, what is the order of execution of this functional map? I mean, whether always Total will be calculated first?

    4. What do you mean by scratch'  output card?

    5. I meant Re usability to  calculate the Total variable once and use it's output  wherever we want.

    6. Lets say I have created a functional map which calculates Total and store the response in Total variable. Now can I call the functional map like this: TotalDifference = (PreviousTotal - f_calculateTotal(In1,In2,In3,In4))? I tried this but the result was always null.

    Thanks

    Uvaise Ahmed


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


  • 4.  Re: Temporary output cards in Functional map

    Posted 06/13/18 05:29 AM

    Originally posted by: PaulBrett


    I have made a short video that shows how the mapping is done using drag and drop:

    https://drive.google.com/open?id=15mBu7hdlmNcicZTTkBA9i1nHzVbXL853

    Thank you.

    Paul

    Follow me on Twitter


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


  • 5.  Re: Temporary output cards in Functional map

    Posted 06/13/18 05:38 AM

    Originally posted by: uvaiseodam


    Thanks for the demo Paul. Now I know how to do it. Could you please answer my other queries?

     

    Thanks

    Uvaise Ahmed


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


  • 6.  Re: Temporary output cards in Functional map

    Posted 06/13/18 06:38 AM

    Originally posted by: PaulBrett


    2. Total = Mathematics+Science+History+Language; TotalDifference = PreviousTotal - (Mathematics+Science+History+Language). Since I couldn't use Total variable to calculate TotalDifference , I used all the variables again to get Total and then subtracted with PreviousTotal . Is there way that  can we create a temporary output card in functional map, calculate Total and store the output. Use the stored value wherever you want in the actual output of the functional map? 

    A.  As I have shown, there is no need to create a temporary output card (whch cannot be done anyway).

    3. If we go with your approach as per your Example, what is the order of execution of this functional map? I mean, whether always Total will be calculated first?

    A.  The rules are always executed in order

    4. What do you mean by scratch'  output card?

    A. 'scratch' card = temporary output card

    5. I meant Re usability to  calculate the Total variable once and use it's output  wherever we want.

    A.  My example shows how the result can be used in a later rule (in the functional map)

    6. Lets say I have created a functional map which calculates Total and store the response in Total variable. Now can I call the functional map like this: TotalDifference = (PreviousTotal - f_calculateTotal(In1,In2,In3,In4))? I tried this but the result was always null.

    A.  Your functional map call should include the 'Total:sequence:Out' reference, (as per my map) where the calculatoin has already been done.  So far example:

    =F_NextLevel(PreviousTotal:sequence:In1 , Total:sequence:Out)

    Thank you.

    Paul

    Follow me on Twitter


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


  • 7.  Re: Temporary output cards in Functional map

    Posted 06/13/18 06:41 AM

    Originally posted by: uvaiseodam


    Thanks Paul. You always comes to rescue :)


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