Concat
Description
Joins multiple argument values of any data type together as a string value and returns the value in a new column. Specified characters can be added between the joined column values.
As there is no "ToString" function available, the Concat function can be used to accomplish this action by using it with a single input value.
Use
- Argument:
- Select an argument. (Any)
- Optional: Select additional arguments. (Any)
- Output field:
- Enter an output field name.
- Joiner:
- Optional: Enter joining characters added between concatenated values.
Examples
Joining a First and Last Name
In this example ,there is a first name input field and a last name input field. The user wants both the first and last name separated by a blank space within the same field.
First name | Last name | Concat() joiner | Concat() returns |
---|---|---|---|
Jeff | Murphy | <blank space> | Jeff Murphy |
Joining Two Street Names Into an Intersection
In this example, there are two street names. The user wants to combine the street names using the joining word "and".
Street1 | Street2 | Concat() joiner | Concat() returns |
---|---|---|---|
Broadway | Seventh Avenue | <blank space>and<blank space> | Broadway and Seventh Avenue |
Hero Platform_ Example
An example of this function can be found in Hero Platform_'s library of examples.
Download the example titled "function_Concat" to see an example of this function.