Mapping Multi-Select Fields

Mapping Multi-Select Fields

When working with Import, Synchronization, or Data Flow integrations and needing to map multi-select fields with different values between the source and target, you can use Expression Mapping. Expression mapping allows using simple and complex expressions and formulas to transform source data into target field values.

For example, if the source column contains values such as 1, 2, 3, and the target column requires corresponding values like A, B, C, you can use the following expression (adjusting it to match your specific column names and values):

replace_null(string(SourceColumn), ‘’) == ‘1’ ? ‘A’ :
(replace_null(string(SourceColumn), ‘’) == ‘2’ ? ‘B’ :
(replace_null(string(SourceColumn), ‘’) == ‘3’ ? ‘C’ : ‘’))

You can customize this expression for your use case by replacing the column name, modifying parameter values, or adding additional value mappings as needed.

    • Related Articles

    • Salesforce Audit Fields: Quick Insertion Guide

      To use audit fields for the INSERT operation in Skyvia, please enable the 'Create Audit Fields' permission in your Salesforce instance. More details can be found here. Below are the steps to enable the permission: Go to Setup → User Interface. Enable ...

    • BigCommerce: "The value of the column Categories has incorrect JSON format" error

      When working with the Categories field in the Product object within the BigCommerce API, it's important to understand how to format and import data correctly to ensure a successful import. In the BigCommerce API, the Categories field in the Product ...

    • Working with Mailchimp Custom Merge Fields

      In some scenarios, you can encounter difficulties with accessing custom Mailchimp fields. To access custom (merge) fields, please follow these steps: Open your Mailchimp connection and ensure that "Merge Fields Behavior" is set to "Join All Merge ...

    • Mapping the RowNo Column for UPDATE/UPSERT Operations for Google Sheets

      When implementing UPDATE/UPSERT operations in Google Sheets, you may need to set up mapping for the RowNo mandatory field. RowNo is a unique auto-generated row number in the Sheet. It is essential for performing UPSERT/UPDATE operations, as it ...

    • Resolving ActiveCampaign Backup Errors (403 Forbidden)

      Sometimes, when running an ActiveCampaign backup, users may encounter the following error: The remote server returned an error: (403) Forbidden This happens when the ActiveCampaign API receives too many requests in a short period, especially if ...