Map Multi-Select Fields with Expression Mapping - Skyvia

Mapping Multi-Select Fields

Overview

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.

Expression Example

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.

Useful Links

    • Related Articles

    • Salesforce Audit Fields: Quick Insertion Guide

      Overview Audit fields in Salesforce (such as CreatedDate, CreatedById, LastModifiedDate, LastModifiedById) are system fields that track when and by whom a record was created or modified. By default, these fields are read-only and cannot be set during ...

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

      Overview When working with the Categories field in the Product object within the BigCommerce API, it is important to format the data correctly to ensure a successful import. In the BigCommerce API, the Categories field is an array. For more ...

    • Brevo Attributes Field: Mapping Rules and Override Behavior

      Overview When working with Brevo contacts, the fields Attributes_FirstName, Attributes_LastName, and Attributes_Phone are provided as standalone fields for convenience, as they are universal to all users. However, for adding or updating custom ...

    • Working with Mailchimp Custom Merge Fields

      Overview In some scenarios, you may encounter difficulties accessing custom Mailchimp fields in Skyvia. This article explains how to configure the Merge Fields Behavior setting to make custom (merge) fields available in your integration. Steps to ...

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

      Overview When performing UPDATE or UPSERT operations on Google Sheets data in Skyvia, the RowNo field is mandatory. RowNo is a unique auto-generated row number assigned to each row in the sheet. Skyvia uses it to identify which row to update. Without ...