# 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](/files/-Me1q6TA1SZYPKhPzXr4)

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 ](/files/-Me1rhkVHFYZwgGDBXa3)

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

![Pipeline code verification without any errors](/files/-Me25536El_OLJ9mxvqT)

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.](/files/-Me27v1qM8wLqaQ61wOo)

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.](/files/-Me28vaVs3uAKBfwJV5P)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.cloudfabrix.io/rda/rda-userguide/rda-aiops-studio/examples-jupyter/data-mapping-cfxdm-dm-functions/join.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.