Search

x[TEXTLIST:y]

The TEXTLIST function lets you combine the individual text cells into a comma-separated list. The mapping determines which items in the source are combined into each cell of the result. Both the source and the result must have the data type Text.

Syntax

x[TEXTLIST:y] 

where:

  • x: Source
  • y: Result location

Format

Input Format Output Format

x: data type text.

y: list-format used to map where to post the result.

Text

Arguments

The function uses the following arguments:

  • x: Text: Text-formatted line item, text constant, or general expression.
  • y: Text: Text-formatted line item, text constant, or general expression.

Constraints

The function has the following constraints:

  • Both the source and the result must be of data type Text.
  • The TEXTLIST function cannot be used with the Users list.

Excel equivalent

Back to Top

Example

Suppose you want to concatenate the list of fruit products sold to each customer into a single cell. The Source Customers module uses a transactional record list and line items as dimensions. Product Text is list or text-formatted line item. The Customers line item is list-formatted to a list of customers (containing Customer A, Customer B, and so forth).

Customer Summary module uses Customers list as line items, set as columns. The TEXTLIST Products result line item is text-formatted.

Source Customers.Product Text[TEXTLIST: Source Customers.Customers]        

The TEXTLIST aggregation function has a built in limit of 10,000 characters to prevent enormous text strings being created. At 10,000 characters it will stop appending to the list and add an ellipsis. that indicates more items. The ellipsis comes right at the end of the 10,000 character limit, so that if you append two strings that have already been truncated you won't get multiple ellipses, but it does mean that the last name will be truncated rather than stopping at the last full name that will fit. The TEXTLIST aggregation function uses a comma separator, but commas appearing in the source text are allowed.

Back to Top

Similar functions