I'm mapping 3 separate pick list fields from our DAM tool into a single field pick list in Workfront. I've been able to split the values (which come from the webhook as a unique ID and are mapped to their Workfront value) switch the values for the Workfront values and then combine them successfully. The output is 2 separate values coming.
![KIMBERLYREA_2-1689269097014.png KIMBERLYREA_2-1689269097014.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/60091i20197210C0A347C3/image-dimensions/271x231?v=v2)
I have added a hidden value to all my fields called "Aprimo Data Mapping Error" so the request goes through and we don't stop the work for a data issue.
In the DAM tool, if you select a value from Business Unit, the other 2 fields are "Not Applicable" which is causing the "Aprimo Data Mapping Error" to come through.
![KIMBERLYREA_3-1689269223887.png KIMBERLYREA_3-1689269223887.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/60092i283B9FDF021A6779/image-dimensions/191x276?v=v2)
I'm then going in and flattening the Business Unit field but it's pulling the first output.
![KIMBERLYREA_4-1689269315735.png KIMBERLYREA_4-1689269315735.png](https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/60093i792200F5288F034F/image-size/medium?v=v2&px=400)
QUESTION: How do I skip the value "Aprimo Data Mapping Error" so it takes the actual value to map?
@AndyHess Any ideas? I have integration consulting hours but there's no consultants available for a while for me.