mapping of property

Hi,

I have created a list with members : A,B,C. This has a property with values 1,2,3 respectively which is also a list. Now in my list with 1,2,3 members, I need to map the values A,B,C (list) so that 1=A, 2=B, 3=C as shown in screenshot below :

Is there a formula to automatically link the Property in List 123, to List ABC highlighted in yellow?

Thanks,
Ana

Accepted answers

All comments

prabhu

Hi @Ana22,

Is there any condition that you have to use only property.

Easy way is, if you assign code as 1,2,3 for List item A,B,C respectively.

Then using finditem() function you can easily get the result.

Formula for x is item('Dimension List')

As per Anaplan best practice, don't create properties instead create a properties module with corresponding line items which you have to set as properties.

Let me know if it helps.

Ana22

Hi, Thanks, but the 2 lists cant use the code column. They have different code convention. I just need it as property. If I create a module and add that as line item, what is the formula so I can link it?

Thanks,
Ana

eije.wiersema

Hello Ana,

Could it happen that you will have one to many mapping?

1 = A, B

2 = C

or is there always a one to one mapping?

Regards,

Eije

Ana22

HI,

NO, it's one is to one. Or it could be as follows :

1=A

2=B

3=B

4=C

Thanks

Ana

kavinkumar

HI @Ana22,

Let's use the System modules to hold any attributes of a list as part of Anaplan Best Practice. You may have to use TEXTLIST functionality to achieve this result. Example below.

Note: This would work only if there is one to one mapping between these 2 lists.

I hope it helps!

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
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…
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.…