I am confused what is the exact difference between Value Mapping vs Value Mapping(Flattering).

In real world scenario where we should used Value Mapping and Value Mapping(Flattering).

Any example would be

Difference between these two functoid is how they are mapped to destination.

• If value of the incoming field cannot be mapped then Value Mapping Functoid will create an empty destination node ();
• While Value Mapping Functoid (Flattening) will not created an empty node.
• This default behavior of Value Mapping Functoid can be changed with the help of other functoid and scripting

For reference you can look into below MSDN and sandro articles

BizTalk Document Mapping Value Mapping Functoid and Value Mapping (Flattening) Functoid

Value Mapping Functoid vs Value Mapping (Flattening) Functoid Reference

Thanks

Abhishek

Difference between these two functoid is how they are mapped to destination.

• If value of the incoming field cannot be mapped then Value Mapping Functoid will create an empty destination node ();
• While Value Mapping Functoid (Flattening) will not created an empty node.
• This default behavior of Value Mapping Functoid can be changed with the help of other functoid and scripting

For reference you can look into below MSDN and sandro articles

BizTalk Document Mapping Value Mapping Functoid and Value Mapping (Flattening) Functoid

Value Mapping Functoid vs Value Mapping (Flattening) Functoid Reference

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator 1 hour 31 minutes ago

Difference between these two functoid is how they are mapped to destination.

• If value of the incoming field cannot be mapped then Value Mapping Functoid will create an empty destination node ();
• While Value Mapping Functoid (Flattening) will not created an empty node.
• This default behavior of Value Mapping Functoid can be changed with the help of other functoid and scripting

For reference you can look into below MSDN and sandro articles

BizTalk Document Mapping Value Mapping Functoid and Value Mapping (Flattening) Functoid

Value Mapping Functoid vs Value Mapping (Flattening) Functoid Reference

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, July 14, 2015 5:33 AM

Difference between these two functoid is how they are mapped to destination.

• If value of the incoming field cannot be mapped then Value Mapping Functoid will create an empty destination node ();
• While Value Mapping Functoid (Flattening) will not created an empty node.
• This default behavior of Value Mapping Functoid can be changed with the help of other functoid and scripting

For reference you can look into below MSDN and sandro articles

BizTalk Document Mapping Value Mapping Functoid and Value Mapping (Flattening) Functoid

Value Mapping Functoid vs Value Mapping (Flattening) Functoid Reference

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, July 14, 2015 5:33 AM

Difference between these two functoid is how they are mapped to destination.

• If value of the incoming field cannot be mapped then Value Mapping Functoid will create an empty destination node ();
• While Value Mapping Functoid (Flattening) will not created an empty node.
• This default behavior of Value Mapping Functoid can be changed with the help of other functoid and scripting

For reference you can look into below MSDN and sandro articles

BizTalk Document Mapping Value Mapping Functoid and Value Mapping (Flattening) Functoid

Value Mapping Functoid vs Value Mapping (Flattening) Functoid Reference

Thanks

Abhishek

• Marked as answer by Angie xuMicrosoft contingent staff, Moderator Tuesday, July 14, 2015 5:33 AM

Hi PS(India),

I agree with Mr. Abhishek and ll want to add some text,

As Value Mapping Functoid description states that if your destination is flat file then u should have use Value-Mapping(Flattering).