Supressing records while mapping in Biztalk

If you have situations where you dont want to copy all the repeating records from source schema to destination schema then you need to perform "Logical gating". There is a very usefull feature of mapper that is not known to most of us.

If you map a 'logical false' value to any node on the output schema, then that node will not be created. It means you can use logical functoids to evaluation the condition on which you dont want the record to be copied. See the example below, I guess that should be more easier.



In this examle you perform the regular mapping. But I would like to map only those records whose RefType ='Friends'. I have added a logical '=' functoid. The first parameter is the RefType node while the second is a constant string 'Friend'. The output is assigned to 'Reference' node

No comments: