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.
- x: Source
- y: Result location
|Input Format||Output Format|
x: data type text.
y: list-format used to map where to post the result.
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.
Use TEXTLIST with the Users list
You can reference the Users list with the TEXTLIST function. However, you cannot reference specific users within the Users list as this is production data, which can change and make your formula invalid.
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.
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.