mapping of property

Highlighted
Contributor

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 :

Ana_M_0-1585829606855.png

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

 

Thanks,
Ana

5 REPLIES 5
Highlighted
Super Contributor

Re: mapping of property

Hi @Ana_M,

 

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.

 

 

Capture1.JPG

 

 

Formula for x is item('Dimension List')

 

Capture3.JPG

 

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.

Sorna Raja Prabhu
Highlighted
Contributor

code Re: mapping of property

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

Highlighted
Master Anaplanner/Community Boss

Re: mapping of property

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

Highlighted
Contributor

Re: mapping of property

HI,

 

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

 

1=A

2=B

3=B

4=C

 

Thanks

Ana

Highlighted
Master Anaplanner/Community Boss

Re: mapping of property

HI @Ana_M,

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.

image.png

image.png

image.png

 

 

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

I hope it helps!

Regards,
Kavin.