How to Use the Item Export Flow for Real and Virtual Matrix Items

Problem

How do we map a conditional statement within the 'Map Variation Specifics' to pick between the 2 fields based on the type of matrix? 

Solution

Create a new custom field which source from custitem_color for matrix items and custitem_virtual_color for virtual variation items and add that field in Variation Specific Setting mapping in IO. Use the formula as: CASE WHEN {custitem_celigo_virtualvariation} = 'T' THEN {custitem_virtual_color} ELSE {custitem_color} END.