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.  i have a problem with functional map

    Posted 09/26/08 10:55 AM

    Originally posted by: muralee


    Hi,

    i have a functional map with 3 input cards.

    =f_function(grp1,grp2,grp3)

    some times the grp2 and grp3 will have no data.then the functional map is not working.

    grp1-will hava data.
    grp2 and grp3-are optional groups.

    if grp1,grp2 and grp3 have data then i will map all the 3 groups to output card.
    if grp2 or grp3 didn't have data then i will map grp1 and grp2 or grp3 to output card.

    please help me out to solve this issue.

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


  • 2.  Re: i have a problem with functional map

    Posted 09/26/08 11:16 AM

    Originally posted by: john.gibby


    If grp2 or grp3 do not have data, the functional map will not be executed. You will need to do one of two things I have found works.

    1. Create a three secondary functional maps for when grp2 or grp3 are not present.

    
=EITHER( IF( PRESENT(grp2) & PRESENT(grp3), F_FunctionalMap(grp1,grp2,grp3) ), IF( NOT(PRESENT(grp2)) & NOT(PRESENT(grp3)), F_FunctionalMap_Only_grp1(grp1) ), IF( NOT(PRESENT(grp2)), F_FunctionalMap_No_grp2(grp1,grp3) ), F_FunctionalMap_No_grp3(grp1,grp2) )


    2. Create dummy grp2 & grp3 output cards for use when actual grp2 and/or grp3 are not present. In which case, you'll have to build logic into your functional map that will be able to detect the dummy groups.

    
=F_FunctionalMap( grp1, EITHER(grp2,dummy_grp2), EITHER(grp3,dummy_grp3) )


    Good Luck!
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


Related Content