IIF() function in Data Prep mapping UI Calculated Field not populating variables as expected. Hello, My XDM schema has a "userId" field that should receive one of three possible ids in the source data payload, based on which source id is available, using the Calculated Fields IIF() function. So if "sourceId1" is available, it should always be used - if "sourceId1" is not available, "sourceId2" should be used, and if both those are not available, "sourceId3" should be used. We are sending data to AEP via the Edge Network Server API and mapping source properties to our schema via the data prep mapping UI. Source data is structured like this: {
"xdm": {
"_myorg":
{
"sourceId1": 'aaa',
"sourceId2": 'bbb',
"sourceId3": 'ccc'
}
}
} The IIF() statement I am trying to use is like this, mapping the result to "userId". iif(${xdm\._myorg\.sourceId1} == '' || !${xdm\._myorg\.sourceId1} , (iif(${xdm\._myorg\.sourceId2} == '' || !${xdm\._myorg\.sourceId2} , ${xdm\._myorg\.sourceId3}, ${xdm\._myorg\.sourceI