# Join

**join**\
Joins input list using an optional separator. \
@param **sep** (optional), default value is ' ' . Input is expected to be a list. \
If the input is not a list, it returns the value without joining.

This function allows users to join the columns using a separator token.

### Example 1: 

Step 1: Create an empty **join\_example\_1** using AIOps studio as shown in the below screenshot.

![Empty join\_example pipeline](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me1q315QNGJfscTcMfh%2F-Me1q6TA1SZYPKhPzXr4%2FScreen%20Shot%202021-07-07%20at%202.20.27%20PM.png?alt=media\&token=49b79502-1b0d-40e9-82b1-5c7f1db9bc43)

Step 2: Add the following pipeline code/commands into the above-created pipeline as shown in the below screenshot:

You can copy the below code into your pipeline and execute that in your environment.\
\
\&#xNAN;*`##### This pipeline creates a simple record using AIOps studio.`*\
\
*`##### RDA function join is used to demo this example.`*\
*`##### This function uses different columns and join them using a separator character`*\
*`##### Function 'join' is used join the column values using a user provided separator`*\
\
*`@dm:empty`* \
*`--> @dm:addrow A = "Hello" & B = "World" & C = "Join" & D = "Example"`*\
*`--> @dm:map from = "A,B,C,D" & to = "X" & func = "join" & sep = ","`*<br>

![Pipeline code ](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me1rPOzeu123SPDPmGi%2F-Me1rhkVHFYZwgGDBXa3%2FScreen%20Shot%202021-07-07%20at%202.27.54%20PM.png?alt=media\&token=c652f2d2-01ab-491b-942e-96d8f80c6c33)

Step 3: Click verify button to make sure syntax and pipeline code is correct (as shown below)

![Pipeline code verification without any errors](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me24nBbLo_sRjPRnmP4%2F-Me25536El_OLJ9mxvqT%2FScreen%20Shot%202021-07-07%20at%203.30.42%20PM.png?alt=media\&token=f8d489cf-0458-46c9-aee7-adb35a1d86d4)

Step 4:  Click execute button and execute the pipeline. RDA will execute the pipeline without any errors (as shown below)

![Pipeline execution without any errors.](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me27gxWHtmYvQx_pVNS%2F-Me27v1qM8wLqaQ61wOo%2FScreen%20Shot%202021-07-07%20at%203.43.04%20PM.png?alt=media\&token=7764cd4d-1177-47a0-8058-b874eccdf58d)

Step 5: RDA uses the function 'join' to join all the column values with a separate token "," and displays the output as shown in the below screenshot.

![RDA function join will join the values using separator token and displays the data.](https://2978683539-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LhoMVYxiQlKXh6OxX98%2F-Me28J9susFzdUSLtslG%2F-Me28vaVs3uAKBfwJV5P%2FScreen%20Shot%202021-07-07%20at%203.47.23%20PM.png?alt=media\&token=449d9106-a879-4eff-b686-a0dd1ffece68)