The TEXTLIST function concatenates a series of text values into a single text value.
TEXTLIST
For example, you can produce a list of products sold in a given region.
TEXTLIST(Text to concatenate, Separator, List to reference [, Duplicate behavior])
Arguments
| Argument | Data type | Description |
| Text to concatenate(required) | Text line item | An expression that evaluates to a text line item. |
| Separator(required) | Text | The text value to use as a separator between each text value concatenated. |
| List to reference(required) | List | The list that determines the order in which to concatenate the values from theText to concatenateargument. |
| Duplicate behavior | Keyword | Determines whether duplicated text values should be listed once or multiple times. |
The TEXTLIST function returns a text value.
Duplicate behavior keywords
| Keyword | Description |
| ALL | If theText to concatenateargument contains multiple instances of the same text, each instance is listed in the result. The default behavior if you omit theDuplicate behaviorargument. |
| UNIQUE | If theText to concatenateargument contains multiple instances of the same text, only the first instance is listed in the result. |
Syntax example
TEXTLIST('Regional product sales.Products', ", ", Regions, UNIQUE)
Additional information
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 isproduction data, which can change and make your formula invalid.
Constraints
Character limit
The TEXTLIST function has a limit of 10,000 characters. This is to prevent the creation of text values that are too large and affect model performance.
If the result of the text function would exceed 10,000 characters, the function stops appending characters and adds an ellipsis (…) to indicate there's more.
Calculation engine functionality differences
You cannot use the TEXTLIST calculation function in Polaris.
In the Classic engine, you can.
Excel equivalent
Examples
General example
This example uses two modules. The first module,Sales Transactions, has two line items on columns that contain the customer name and the value of transactions. TheTransactionslist is on rows. TheRegionslist is a page dimension, and London is currently selected.
Sales Transactions
Region: London
| Customer | Transaction Value | |
| Transaction 01 | 0 | |
| Transaction 02 | Fairgreen Furniture Ltd | 20,000 |
| Transaction 03 | Carpenter Oak Ltd | 15,000 |
| Transaction 04 | Carpenter Oak Ltd | 20,000 |
| Transaction 05 | Bluebottle Inc | 5,000 |
| Transaction 06 | 0 | |
| Transaction 07 | Purple Haze & Co | 2,000 |
| Transaction 08 | Fairgreen Furniture Ltd | 1,000 |
| Transaction 09 | Brass Monkeys Inc | 1,000 |
| Transaction 10 | Purple Marine Stores | 1,000 |
| Transaction 11 | 0 | |
| Transaction 12 | Purple Marine Stores | 5,000 |
The second module,List of customers, has three line items on columns. TheRegionslist is on rows. The London row corresponds to the example above.
The first two line items contain formulas that show a list of customers by region. The formula in theList of all customersline item uses the ALL keyword for theDuplicate behavior关键字,所以returns duplicated text values multiple times. The formula in theList of all customers without duplicatesline item uses the UNIQUE keyword for theDuplicate behaviorkeyword, so it does not return duplicated text values.
List of customers
List of all customers
|
List of all customers without duplicates
|
Total Transactions Value
|
|
| London | Fairgreen Furniture Ltd, Carpenter Oak Ltd, Carpenter Oak Ltd, Bluebottle Inc, Purple Haze & Co, Fairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine Stores, Purple Marine Stores | Fairgreen Furniture Ltd, Carpenter Oak Ltd, Bluebottle Inc, Purple Haze & Co, Brass Monkeys Inc, Purple Marine Stores | 66,000 |
| Birmingham | Fairgreen Furniture Ltd, Fairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine Stores | Fairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine Stores | 110,000 |
| UK | 176,000 | ||
| Paris | Électricité Berlioz S.A., Amiot S.A | Électricité Berlioz S.A., Amiot S.A | 75,000 |
| Lyon | Dufay S.A., Dufay S.A., Jean Françaix S.A, René Désiré S.A. | Dufay s.a.,琼Francaix s.a.,René Désiré S.A. | 104,000 |
| France | 179,000 | ||
| Munich | Hans-Jürgen GmbH, Von Bose AG | Hans-Jürgen GmbH, Von Bose AG | 58,000 |
| Berlin | Klughardt GmbH, Offenbach AG, Offenbach AG, Telemann GmbH | Klughardt GmbH, Offenbach AG, Telemann GmbH | 202,000 |
| Germany | 260,000 | ||
| New York | Anderson International Inc., Cummings Industries Inc., Headley Inc., Headley Inc. | Anderson International Inc., Cummings Industries Inc., Headley Inc. | 200,000 |
| Los Angeles | Kennedy Inc, ABC Inc | Kennedy Inc, ABC Inc | 20,000 |
| USA | 220,000 | ||
| Total Company | 835,000 |
Disclaimer
We update Anapedia content regularly to provide the most up-to-date instructions.