Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
1 reply Latest Post - ‏2012-03-30T16:25:33Z by Jean_Anderson
DGardner
DGardner
1 Post
ACCEPTED ANSWER

Pinned topic Which Mashup Operator is best for....

‏2012-03-30T14:04:10Z |
First...I'm a newbie.

I am reading two feeds. Each feed has a common element value (a product ID), though the element name is not the same. I would like to produce a single output feed that only has rows that had a matching ID value in both input feeds.

I have been struggling with 'Combine', 'For Each', 'Merge' and even 'Group'. This seems like it would be a common task? Can anyone point me in the right direction for the best approach
Updated on 2012-03-30T16:25:33Z at 2012-03-30T16:25:33Z by Jean_Anderson
  • Jean_Anderson
    Jean_Anderson
    27 Posts
    ACCEPTED ANSWER

    Re: Which Mashup Operator is best for....

    ‏2012-03-30T16:25:33Z  in response to DGardner
    Hi,

    Let's say that the element name in Feed1 is Name1 and the element name in Feed2 is Name2. You should be able to merge where Feed1->Name1 = Feed2->Name2. The insurance example might help:

    http://publib.boulder.ibm.com/infocenter/mashhelp/v3/topic/com.ibm.examples.doc/insurance_example.htm

    It is a little more complicated because the second value is the result of a function.

    In your case, I suggest trying the following after you add the Merge operator (substituting your actual feed and element names:

    • First Input Value:

    1. Verify that the First Input field is Feed1. If it isn't,
    change the First Input field to Feed1 to obtain the proper
    input tree.
    2. Click the arrow in the box under First Input Value and
    choose Specify a value from the Input tree.
    3. Expand to the Name1 element, and select the text value
    under it.
    4. Click OK.

    • Comparison: =

    • Second Input Value:

    1. Verify that the Second Input field is Feed2. If it isn't,
    change the Second Input field to Feed2 to obtain the proper
    input tree.
    2. Click the arrow in the box under Second Input Value and
    choose Specify a value from the Input tree.
    3. Expand to the Name2 element, and select the text value
    under it.
    4. Click OK.

    Please let us know if this works for you -- or if I have misunderstood the question.

    regards,

    -jean