Array join transform function
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:
...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):
Adding an array join transform
Step 1 In your process flow, access settings for your map shape:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FaXEkDoJIsEmKG9b1JSTu%252Fnull%2520transform%25201.png%3Falt%3Dmedia%26token%3D73b3cec9-ff2f-4ba8-8a9b-736cbac97f5f&width=768&dpr=4&quality=100&sign=6917dd&sv=1)
Step 2 Select the add transform icon for the required mapping rule - for example:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FB654ER7t1L9Dkc6bXyqO%252Farray%2520join%2520transform%2520a1.png%3Falt%3Dmedia%26token%3D2aa8c195-d8be-49ec-932d-4faa196bb4b2&width=768&dpr=4&quality=100&sign=8e1cfc31&sv=1)
Step 3 Click the add transform button:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252F3LdnN37gMP8KWtXcUgd5%252Farray%2520join%2520transform%25201a.png%3Falt%3Dmedia%26token%3Decf18911-c050-48cb-b11b-610a741459a1&width=768&dpr=4&quality=100&sign=9a9ff943&sv=1)
Step 4 Click in the name field to access a list of all available transform functions, then select join from the array category:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FO5LsD0HUpzKaQqC9euMH%252Farray%2520join%2520transform%25202.png%3Falt%3Dmedia%26token%3D879a7afb-5cf5-4c00-8bd2-58ed5bef439f&width=768&dpr=4&quality=100&sign=fb93bd05&sv=1)
Step 5 In the delimiter field, enter the character that you want to use to delimit each array field in the string:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252Fe8WfQUWBVUPMM0WExo3I%252Farray%2520join%2520transform%25203.png%3Falt%3Dmedia%26token%3D19bc068f-474a-4284-be51-7e25545e649c&width=768&dpr=4&quality=100&sign=dbc7cac7&sv=1)
A space is a valid character.
Step 6 Click the add field button:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FpGY7fOWG7Fu8c9LXQ6gm%252Farray%2520join%2520transform%25204.png%3Falt%3Dmedia%26token%3D0235d33a-c928-4cff-9cb7-d6b7b9ec4b85&width=768&dpr=4&quality=100&sign=c25f54ec&sv=1)
Step 7 Click in source fields and select the source field to be used for this transform:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FiKb0mDjrrr4WtwXSowH2%252Farray%2520join%2520transform%2520a2.png%3Falt%3Dmedia%26token%3D02dbaac1-5181-41ec-a5c0-94d6c21401a0&width=768&dpr=4&quality=100&sign=adb1ce4e&sv=1)
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:
![](https://doc.wearepatchworks.com/~gitbook/image?url=https%3A%2F%2F2440044887-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FLYNcUBVQwSkOMG6KjZfz%252Fuploads%252FdtP11Iq8V7vaqsgXbK7n%252Farray%2520join%2520transform%2520a3.png%3Falt%3Dmedia%26token%3Debd61562-fb82-4895-af41-83d274ba2911&width=768&dpr=4&quality=100&sign=381c8793&sv=1)
Last updated