How to combine 2 item line in General List's properties?

Dsuci · 2023-07-13T10:24:06+00:00

There was an error rendering this rich post.

Hello everyone,
I'm new in Anaplan and I got problem now.
Could you help me for this case?

So current now I have data such as below :
General List : Supplier

Current now in my screen, I use to filter Product only using "Supplier" -> show Supplier A
But I want to change it become "Code_Supplier" -> show as 001_Supplier A

I got confused how can I make a formula to combine 2 of item line properties in General List.
I use LOOKUP and FIND ITEM like below but it turn out Error,
FINDITEM(SUPPLIER, Code)
LOOKUP(SUPPLIER, Code)

Can anyone please help me to solve this problem?

Thank you so much everyone!

Accepted answers

Tiffany.Rice

Hey there @Dsuci! First, welcome to Anaplan! I hope you are finding our community of model builders to be a warm and welcoming place!

The formula you will need to use is https://help.anaplan.com/code-0e20099c-af47-4343-9ad9-3a20b580d2de and the "Item" you are referencing is the supplier list - CODE('Supplier') as an example. Every list include the option to a Code, this is a foundational list component as it allows you to define the unique identifier which can be huge when importing data from external systems where names may differ but the code is ubiquitous. Thus we use our handy CODE formula rather than a reference to the list properties tab. Hope that helps!

Also, bear in mind in mind the list structure (standard vs. numbered) if you hope to combine the code & supplier description into a formulaically driven display name. https://help.anaplan.com/create-display-names-for-numbered-lists-a916143c-d348-4e0c-afaf-100198dcd2ef

Best wishes!

-Tiffany

jagadishdash

Hi @Dsuci

First of all, Make the supplier list as a numbered list. After that add 2 properties there, (Display Name and Item).

In the General list add the display name property as Display Name. Then Add the list member in the ITEM column.

Create a module with supplier list as a dimension and create a Display Name line item with text format. Then add the formula as shown below.

Then in the List property Display name add the formula.

Hope it helps.

Thanks,

Jagadish

All comments

Tiffany.Rice

Hey there @Dsuci! First, welcome to Anaplan! I hope you are finding our community of model builders to be a warm and welcoming place!

Best wishes!

-Tiffany

Dsuci

Hello @Tiffany.Rice Nice to meet you! 😄

First of all thank you for your answer about my question.

It help me to understand about the Code and Display Name function.

But let me confirm one more thing, so is it impossible if I want to create formula to get the data from CODE and Supplier in properties menu (in each item line)?

For now me and my team use other way to solve this matter,

we create new item line and re-input the new data, and in the filter screen show the format like we want ("Code_Supplier")

Thank you again! 😄

jagadishdash

Hi @Dsuci

First of all, Make the supplier list as a numbered list. After that add 2 properties there, (Display Name and Item).

In the General list add the display name property as Display Name. Then Add the list member in the ITEM column.

Create a module with supplier list as a dimension and create a Display Name line item with text format. Then add the formula as shown below.

Then in the List property Display name add the formula.

Hope it helps.

Thanks,

Jagadish

Tiffany.Rice

Thanks @jagadishdash for creating that mock-up!

@Dsuci - glad you were better able to understand the code vs. display name! Check out Jagadish's example - that should help to solidify the specifics on how you can use list properties and systems modules to facilitate a dynamic display name that concatenates the code + supplier name. Have a wonderful day!

Dsuci

Hello everyone!
THANK YOU SO MUCH FOR YOUR HELP!

Mr. @jagadishdash thank you for the easier example! It really help!
Now my problem is solved. I can create the data like I want!!
Really really thank you!

@Tiffany.Rice thank you for your help too!
It's nice to have someone talk about my case!

Thank you again 😆
Hope you guys have a wonderful day!

-DSuci

Quick Links

Can you help?

Unanswered questions

Dimensionality - Formula Help
I have a Price module where customers are ranked based on their unit prices. I also have a Comparison module, where I want to display the names and unit prices of top-ranked customers for comparison. The model includes a Customers list. In the Comparison module, I want to write formulas to bring in the customer names and…
Can there be a duplication in Process ID's
Can there be a duplication in Process ID's
Using Polaris and Classic
Client has spoke models built in Classic and now considering building Data Hub in Polaris in order to deal with sparsity. On the surface this seem possible but likely a bad idea. Has anyone done anything similar to this? Specifically, what did you have to do to ensure that data was compatible? Any thoughts or suggestions…