INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Many to Many mapping problem

Many to Many mapping problem

(OP)
I have a scenario where I need to replace some elements in an existing message with the contents of another message. Message #2 (the existing message) looks like this:

<Root>
   <Loop2300>
      <Loop2400>
         <LXSegment>
            <LX01_AssignedNumber>1</LX01_AssignedNumber>
         </LXSegment>
         <HCPSegment>
            <HCP02_Amount>0</HCP02_Amount>
         </HCPSegment>
      </Loop2400>
      <Loop2400>
         <LXSegment>
            <LX01_AssignedNumber>2</LX01_AssignedNumber>
         </LXSegment>
         <HCPSegment>
            <HCP02_Amount>0</HCP02_Amount>
         </HCPSegment>
      </Loop2400>
   </Loop2300>
</Root>

And message #1 (the new data) looks like this:


<Root>
   <Header>
      <Detail>
         <ServiceLine>1</ServiceLine>
         <Amount>10.4</Amount>
      </Detail>
      <Detail>
         <ServiceLine>2</ServiceLine>
         <Amount>1.2</Amount>
      </Detail>
   </Header>
</Root>

I want to match up the LX01_AssignedNumber in the first message to the ServiceLine in the second message, and replace the appropriate amounts, so that the output winds up looking like this:

<Root>
   <Loop2300>
      <Loop2400>
         <LXSegment>
            <LX01_AssignedNumber>1</LX01_AssignedNumber>
         </LXSegment>
         <HCPSegment>
            <HCP02_Amount>10.4</HCP02_Amount>
         </HCPSegment>
      </Loop2400>
      <Loop2400>
         <LXSegment>
            <LX01_AssignedNumber>2</LX01_AssignedNumber>
         </LXSegment>
         <HCPSegment>
            <HCP02_Amount>1.2</HCP02_Amount>
         </HCPSegment>
      </Loop2400>
   </Loop2300>
</Root>

I thought I could just use an Equal functoid and compare Service Line to LX01_AssignedNumber, then a Value Mapping functoid, but I wind up with 10.4 for both of them. How would I solve this?

Thanks!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close