Bulk changing a main list

joshkhanzadeh · 2024-04-12T15:48:23+00:00

There was an error rendering this rich post.

joshkhanzadeh

Hi.

We want to update #customer list to include customer numbers, for example:

Current #Customer

London
Manchester
Birmingham

Required #Customer

London (1000)
Manchester (1200)
Birmingham (1400)

How is this done, and will this have impact on history?

Thanks

Accepted answers

All comments

jasonblinn

Hi @joshkhanzadeh ,

Assuming the "#" Means that this is a numbered list, all you will need to do is change the Display name to include the number afterward to make it look the way you want.

If it is not a numbered list, we will need to understand the structure of the list. What does the code look like? Etc.

Jason

joshkhanzadeh

Hi Jason,

The list is numbered (each 'name' has a unique identifying code). Is there anyway to bulk update the names, as we have a few thousand #customer 's, and manual updates would take too long. Thanks

jasonblinn

In the display name property, you can write a formula that says something to the effect of : Description & Code. Basically you just want to concatenate the name that you currently have with the code that you are trying to get there.

I know my example isnt perfect here, but i think it will make sense!

joshkhanzadeh

You're a star! Thanks Jason :)

joshkhanzadeh

Apologies for the next question, what is the reference/ could you explain of (Display Name Example), do we need to build another LI for that?

Thanks

jasonblinn

That is just the name of the list I created for this example. I would think yours would be "#Customer" instead

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled