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 in 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 ...

    • Skyvia Backup Errors Caused by Salesforce API Requirements

      Skyvia interacts with Salesforce via its API. During a backup operation, you may encounter errors due to certain limitations or behaviors specific to the Salesforce API. For example, when Skyvia performs a backup or replication, it queries all the ...