# Concat

#### concat

Adds prefix and suffix to the suffix to the specified string \
                    @param prefix Type string. Optional. default value is ' ' )\
                   @param suffix  Type string. Optional. default value is ' ' )\
                    Input must be a string. If input is null, it is treated an ' ' (empty) string.

This function allows users to concatenate column with additional string data. Additional string values can be provided as 'prefix' and or as 'suffix'. This allows users to modify column values and add additional string values as per need and requirement.

Step 1: Create an empty concat\_example using AIOps studio as shown in the below screenshot

![Empty pipeline 'concat\_example' created in AIOps Studio ](/files/-Mbn90QCHhj0I3tu6EfR)

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 for an attribute (column)`* \
*`##### using AIOps studio.`*\
\
*`##### RDA function concat is used to demo this example.`*\
*`##### This function uses 'prefix' and 'suffix' as additional string values and`* \
*`##### concatenate with original value of column X (attribute)`*\
\
*`@dm:empty`* \
*`--> @dm:addrow X = 'RDA Concat Column'`*\
*`--> @dm:map func = 'concat' & attr = 'X' & prefix = 'Hello ' & suffix = ' World'`*

![](/files/-MbnNA5c0elCm7VA45H_)

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

![](/files/-MbnOpUayk7InRxYC9cc)

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

![Successful execution of pipeline](/files/-MbnPFheE-LBvVOoUX4y)

Step 5:  RDA uses the function to concatenate column with additional string data.  In the current pipeline example, prefix is given as 'Hello' and suffix is given as 'World'.  Function uses these string values and concatenates to the value of column 'X'.\
\
In the current example, attribute 'X' has a value of ''RDA Concat Column' and concat function would change that value to "**Hello RDA Concat Column World"** after successful execution of pipeline (as shown in below screenshot)

![Once the pipeline has been successfully run, function 'concat' will modify and add strings as shown](/files/-MbnPoFG2E9AaHsjslSy)

Similar to the above example, users will be able to modify the other columns (or attributes) based on the requirements.


---

# 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/concat-function.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.