Array join transform function

To view this content in our official product documentation, click here.

Introduction

The array join transform function is used to join elements of an array as a string, with a user-defined delimiter. For example, you might have product data in an array:

{% code lineNumbers="true" %}

{
  "fruit_in": [
    "Apples",
    "Oranges",
    "Pears",
    "Grapes"
  ]
}

...and need to convert these items to a string before pushing to a single destination field (with each item in the string delimited by a character of your choice):

{% code lineNumbers="true" %}

{"fruit_out":"Apples,Oranges,Pears,Grapes"}

Adding an array join transform

Step 1\ In your process flow, access settings for your map shape:

 

Step 2\ Select the add transform icon for the required mapping rule - for example:

 

Step 3\ Click the add transform button:

 

Step 4\ Click in the name field to access a list of all available transform functions, then select join from the array category:

 

Step 5\ In the delimiter field, enter the character that you want to use to delimit each array field in the string:

 

A space is a valid character. If you want to join array items with no spacing or other delimiters, leave this field empty.

Step 6\ Click the add field button:

 

Step 7\ Click in source fields and select the source field to be used for this transform:

 

Step 8\ Accept your changes (twice).

Step 9\ Save the transform. You'll notice that the transform icon is updated to indicate that a transform function is present for the mapping row - for example:

 

Related pages

• Mapping array fields