BizTalk Map error - Decimal output

Hi Everyone,

I am facing issue in a mapping. 

The schema looks as follows :

Source :

Destination :



Liv - Repeating Record

Ava, Bva - Decimal Fields

I have to implement a logic, 

If sid = AB then mapping should not happen for Ava, Bva;

If it is anyother value in sid, then mapping should happen.

Input message

<Liv>
    <Ava>10.4</Ava>
    <Bva>10.4</Bva>
    <Pdt>
      <sid>AB</sid>
    </Pdt>
  </Liv>
  <Liv>
    <Ava>10.4</Ava>
    <Bva>10.4</Bva>
    <Pdt>
      <sid>AB</sid>
    </Pdt>
  </Liv>
  <Liv>
    <Ava>10.4</Ava>
    <Bva>10.4</Bva>
    <Pdt>
      <sid>si</sid>
    </Pdt>
  </Liv>
  <Liv>
    <Ava>10.4</Ava>
    <Bva>10.4</Bva>
    <Pdt>
      <sid>si</sid>
    </Pdt>
  </Liv>

Here mapping should not happen in the first two cases and should happen in the last 2

I have tried using not equal and value mapping functoid, but i am getting some error related to conversion.

Can any one help on this.

&#

September 11th, 2015 2:43am

Hi Anand,

Please try to use Scripting functoid, Equal functoid and Value mapping functoid. with Scripting functoid check the value of sid. and if it's true then map it with destination Ava,Bva.

Your map should look like below,

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 3:04am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics