1. Calculation functions
  2. All Functions
  3. Text functions
  4. TEXTLIST

The TEXTLIST function concatenates a series of text values into a single text value.

For example, you can produce a list of products sold in a given region.

Syntax

TEXTLIST(Text to concatenate, Separator, List to reference [, Duplicate behavior])

Arguments

ArgumentData typeDescription
Text to concatenate (required)Text line itemThe line item that contains the text values to concatenate.
Separator (required)TextThe text value to use as a separator between each text value concatenated.
List to reference (required)ListThe list that determines the order in which to concatenate the values from the Text to concatenate argument.
Duplicate behaviorKeywordDetermines whether duplicated text values should be listed once or multiple times.

The TEXTLIST function returns a text value.

Duplicate behavior keywords

KeywordDescription
ALL

If the Text to concatenate argument contains multiple instances of the same text, each instance is listed in the result.

The default behavior if you omit the Duplicate behavior argument.

UNIQUEIf the Text to concatenate argument 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 is production 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.

Excel equivalent

CONCATENATE

Related Anaplan functions

TEXTLIST aggregation function

The & operator

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. The Transactions list is on rows. The Regions list is a page dimension, and London is currently selected.

Sales Transactions

Region: London


CustomerTransaction Value
Transaction 01
0
Transaction 02Fairgreen Furniture Ltd20,000
Transaction 03Carpenter Oak Ltd15,000
Transaction 04Carpenter Oak Ltd20,000
Transaction 05Bluebottle Inc5,000
Transaction 06
0
Transaction 07Purple Haze & Co2,000
Transaction 08Fairgreen Furniture Ltd1,000
Transaction 09Brass Monkeys Inc1,000
Transaction 10Purple Marine Stores1,000
Transaction 11
0
Transaction 12Purple Marine Stores5,000

The second module, List of customers, has three line items on columns. The Regions list 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 the List of all customers line item uses the ALL keyword for the Duplicate behavior keyword, so it returns duplicated text values multiple times. The formula in the List of all customers without duplicates line item uses the UNIQUE keyword for the Duplicate behavior keyword,  so it does not return duplicated text values.

List of customers


List of all customers

TEXTLIST(Sales Transactions.Customer, ", ", Transactions, ALL)

List of all customers without duplicates

TEXTLIST(Sales Transactions.Customer, ", ", Transactions, UNIQUE)

Total Transactions Value

Sales Transactions.Transaction Value

LondonFairgreen Furniture Ltd, Carpenter Oak Ltd, Carpenter Oak Ltd, Bluebottle Inc, Purple Haze & Co, Fairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine Stores, Purple Marine StoresFairgreen Furniture Ltd, Carpenter Oak Ltd, Bluebottle Inc, Purple Haze & Co, Brass Monkeys Inc, Purple Marine Stores66,000
BirminghamFairgreen Furniture Ltd, Fairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine StoresFairgreen Furniture Ltd, Brass Monkeys Inc, Purple Marine Stores110,000
UK

176,000
ParisÉlectricité Berlioz S.A., Amiot S.AÉlectricité Berlioz S.A., Amiot S.A75,000
LyonDufay S.A., Dufay S.A., Jean Françaix S.A, René Désiré S.A.Dufay S.A., Jean Françaix S.A, René Désiré S.A.104,000
France

179,000
MunichHans-Jürgen GmbH, Von Bose AGHans-Jürgen GmbH, Von Bose AG58,000
BerlinKlughardt GmbH, Offenbach AG, Offenbach AG, Telemann GmbHKlughardt GmbH, Offenbach AG, Telemann GmbH202,000
Germany

260,000
New YorkAnderson International Inc., Cummings Industries Inc., Headley Inc., Headley Inc.Anderson International Inc., Cummings Industries Inc., Headley Inc.200,000
Los AngelesKennedy Inc, ABC IncKennedy Inc, ABC Inc20,000
USA

220,000
Total Company

835,000