Concat List Items

Description

Joins the elements within list data construct values into a string and returns the string value in a new column. A character sequence can be entered and is inserted between each list element in the returned string value.

If a list argument value is a null, the returned value is also a null.

Use

  • Input field:
    • Select an argument. (List)
  • Joiner:
    • Enter joining characters added between concatenated values.
  • Output field:
    • Enter an output field name.

Example

A user has a field containing list values. The user wants the elements from the list returned as a string value.

List dataJoinerConcat List Items() returns
[Red, Blue, Green]-Red-Blue-Green

Hero Platform_ Example

An example of this function can be found in Hero Platform_'s library of examples.

Download the example titled "function_Concat_List_Item" to see an example of this function. 


Type

Formulas