Biztalk mapper logic

Hello.

I’m assuming the records will always be in order and it is either 1 record or two.

In the past, we use the code below to compare the current value with the past value. It would return true (for them being the same) or false (if different).

You can use a scripting functoid with code like this to return true or false:

string sPastValue = \”\”;
string bReturn = \”\”;

public string M1(string param1)
{
if (sPastValue!= param1)
{
sPastValue = param1;
bReturn = \”true\”;
}
else
bReturn = \”false\”;

return bReturn;

}

This will let you know what type of mapping you need for the record. Then you can use conditional logic to map or add as needed. For the addition, I might try to use the Index functoid along with a counter in the above script to extract out the two values to add together.

Another option would be to use pure custom XSLT. I would think this would be doing using position() and position()-1 to check values and add them.

I would start in this order and work piece by piece:
Map the whole record as normal using the mapper using a looping functoid
Get the 6 replaced with a 4 on the correct row by using conditional logic
Get the sum to work

Mapper logic is hard to explain in a message and I find playing around with it is something the best way to figure it out.

Hope this helps.