Adding lines of data from a list to a single line in a module

Hello all,

Could anyone advise of an easy way to add multiple lines from a list or module based on my list to another module in a single line?

So my list is a list of products, descriptions, etc and in the list-based module I have a boolean to select specific products, I then would like the list of data to appear in the new module as product 1, product 2, etc Is this possible?

Looking forward to your advice

Phill

Accepted answers

PaulRitner

You could potentially use the TEXTLIST function. There's a 10,000 character limit (and TEXTLIST, I think, can be a performance hog). But it works.

Badam

Hi @pknight@cyt-uk.com,

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

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 the Text to concatenate the argument.
Duplicate behavior	Keyword	Determines whether duplicated text values should be listed once or multiple times.

In your above case, product items should be in a line item, use "," as a separator and the List against which you want to concatenate.

https://help.anaplan.com/textlist-c1e24970-400f-43af-95e7-b34a43253cdb

If the above answer helps you out, please accept it as a solution, which motivates us to contribute more.

Thanks & Regards
Badam Anjani Prasad
Matasma Digital Technologies

All comments

PaulRitner

Hello,

Can you provide an example of the desired output? I don't understand quite what you are asking.

Thanks,

Paul

Venki9902

Hi @pknight@cyt-uk.com ,

As per my understanding, do you want to convert the list, for example, list of 10 records rows(Products) to one single product1, Product2, and so on?

Regards,
Venkatesh

Venki9902

Hi @pknight@cyt-uk.com ,

As per my understanding, do you want to convert the list, for example, list of 10 records rows(Products) to one single product1, Product2, and so on?

Regards,
Venkatesh

pknight@cyt-uk.com

@Venki9902 exactly that! Yes I would like to have each product code displayed in the one line of the module

PaulRitner

You could potentially use the TEXTLIST function. There's a 10,000 character limit (and TEXTLIST, I think, can be a performance hog). But it works.

pknight@cyt-uk.com

@PaulRitner would be able to show an example formula to explain?

Badam

Hi @pknight@cyt-uk.com,

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

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 the Text to concatenate the argument.
Duplicate behavior	Keyword	Determines whether duplicated text values should be listed once or multiple times.

In your above case, product items should be in a line item, use "," as a separator and the List against which you want to concatenate.

https://help.anaplan.com/textlist-c1e24970-400f-43af-95e7-b34a43253cdb

If the above answer helps you out, please accept it as a solution, which motivates us to contribute more.

Thanks & Regards
Badam Anjani Prasad
Matasma Digital Technologies

Karan92

Hi @pknight@cyt-uk.com,

1) Created a Product List with Codes (Same as Names of the product) :- This will help in extracting the name using the text formatted in the supporting module.

2) Created a Module similar to yours just added one Line item (Name of Products - Text Formatted), along with the boolean for selection as you wanted. Dimensioned by Products List.

3) Then Created another module in which only selected products will get concatenated.

Hope this will resolve your query and kindly mark this as a solution if it helped you.

Thanks in Advance
Karan Sinha

pknight@cyt-uk.com

Thanks everyone for all your help,

I managed to get the problem resolved with the textlist but tweaked to include a break function to put the products onto a new line for each one and I can now use it perfectly.

Cheers!

Phill

debapriya

If the Products list doesn't have a top level, then how can we implement the same as shown in the example above by @Karan92 ? Any body any help? TIA!

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…