Mapping of data with combination of properties

PolestarllpAG · 2025-03-04T05:50:27+00:00

There was an error rendering this rich post.

Hi All,

I'm new to Anaplan and still learning it's way, would appreciate any ideas aligning with best practices.

Here's my question:

I have a list with combination of properties say products, location, customer, and for each such combination there's a sales person, now I have Sales transaction data with product, location and customer details, I need to map the sales person to each such sales transaction based on list one. Should I be using a numbered list with combination of properties? or there's other way.

Accepted answers

All comments

lokeshm

@Archit_10 if you are using sales Transaction ID which itself is a unique ID , there is no need to use numbered list. But it varies from case to case . You can achieve same thing from numbered list as well.

When you are building the lists, keep it simple and make sure it should align with all of your formulas.

PolestarllpAG

@Lokesh_Madhu I have created two numbered lists, one for sales transaction and other for sales person at a combination of product, customer and location.

Created one module with sales transaction numbered list, product/customer/location/sales value/ sales person as line item. Imported the sales data here, I got all data except sales person.

Now objective is to get sales person names in this module when the combination matches with that of other list.

devrathahuja

Hi @Archit_10 ,
Since you're using numbered list for sales person you'll have to map the line item with its code as numbered lists do not identify members using its name.

rob_marshall

@Archit_10

Do not use Combination of Properties….For Best Practices, please read The Planual.

https://support.anaplan.com/planual-5731dc37-317a-49fa-a5ff-7fc3926972de

1635834

@Archit_10 - If you're still using combination of properties, you can follow below approach.

For the 1st numbered list (Sales Person list), keep or import code as concatenation of Product Customer Location (this way you don't need to create action with combination of properties as we using code)
For the 2nd module(Sales Transaction), create line item as text with concatenation of Product Customer Location.
Create another lineitem in same module and use finditem function with 1st list, so that you'll be getting Sales Person name.

kakasiu

@Archit_10 Hi, the key concept here is to make sure you have a middleman ( unique ID) to connect all the information with a salesperson.

For List 1 mapping, you have List 1 ID <> Sales Person

For the Sales Transaction List, you have Sales Transaction ID, use this unique ID to get the List 1 ID, and then get the Sales Person,

Quick Links

Can you help?

Unanswered questions

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
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385