IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Table LookUp

    Posted Fri October 08, 2010 09:37 AM

    Hi,

    Can I extract the value using key1, key2 and key3 as input. I am having a string table with 4 fields, attached the screenshot for reference.

    Any flow services from wmpublic can help me in this?
    code.JPG


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Table LookUp

    Posted Fri October 08, 2010 11:53 AM

    pub.string:lookupTable can be used for your requirement.


    #webMethods
    #Flow-and-Java-services
    #Integration-Server-and-ESB


  • 3.  RE: Table LookUp

    Posted Tue October 12, 2010 08:43 AM

    the pub.string.lookup, the keycolumn index is a string, so accepts one key only. But my case is I need to probide 3 inputs and based on the input I need to retrieve the result.

    Any suggestion deeply appreciated.

    :mad:


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services


  • 4.  RE: Table LookUp

    Posted Mon October 18, 2010 02:34 PM

    Hello,

    Here is a workaround. You can maintain lookup table with two columns. First three key columns can be combined into one column Keys, concatinate the columns values. So when you want to pass three inputs concatinate the three inpus, pass it to lookup and get the value.


    #Integration-Server-and-ESB
    #Flow-and-Java-services
    #webMethods


  • 5.  RE: Table LookUp

    Posted Mon October 25, 2010 09:08 AM

    Hi Sasanka,
    Since you are having the string table with four different columns, none of the inbuilt services can be used directly on the data. So better write a service which will loop over the string table values and provide a branch condition which will compare the first three field values with the inputs and provides the output as the value from the fourth field.


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services