How to FINDITEM without CODE

taku.s

Hi everyone,

I would like to get the value from the list using FINDITEM, using a Property other than CODE.

I don't have to use FINDITEM. I woud like to know if there is an alternative.

sample... I would like to use "Any Code".

Could you please give me a solution?

Best regards.

Accepted answers

CommunityMember115881

Hi Takushimozuru,

Yes you can.

The easiest option is to use another list as your new Code format (Any Code list property in your example).

Once you've got that you will need a mapping table between the list you used for your new codes and your Initial list (Test in your example). This mapping will be in the format of Test and applied to the new code list. The formula to used to create this mapping table will be Test.Test Item[firstnonblank:Test.Any Code] (Test.Test Item - this property needs to be created and is simply ITEM(Test))

Once you have created the mapping table, all you have to do is to reference it using a LOOKUP function to retrieve your Test list items in your module.

It is also possible to do it with free text as your new code but it takes more space and requires additional calculations so I would advise against it if you can. If not here below is an example of how to do it. Note that the Flag I'm using in this example is simply a List named "Flag" with one member in it also named "Flag".

Let me know if it's not clear.

Cheers

6 05022020.PNG 7 05022020.PNG 8 05022020.PNG 9 05022020.PNG

All comments

Misbah

@taku.s

FINDITEM allows you to find Names and Codes of the list and not any properties. FindItem allows you to convert text formatted line item into list formatted line item ( which by the way also helps in the validation). Now To answer your question, it depends what are you trying to achieve.

For example,

If you are using a module that has the same list as a dimension then you can just refer it by a simple click.

If you are using a module which has got diff dimension then there has to be a link between the two lists so that you can use LOOKUP and get the value.

Hope that helps

Misbah

CommunityMember115881

Hi Takushimozuru,

Yes you can.

The easiest option is to use another list as your new Code format (Any Code list property in your example).

Once you have created the mapping table, all you have to do is to reference it using a LOOKUP function to retrieve your Test list items in your module.

Let me know if it's not clear.

Cheers

6 05022020.PNG 7 05022020.PNG 8 05022020.PNG 9 05022020.PNG

taku.s

Hi.

Thank you for your reply.

I realize that I needed to create a new module.

I'll try it!

Best regards.

CommunityMember115881

Feel free to post here your design if you can't work it out. I'll take a look

Quick Links

Can you help?

Unanswered questions

How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…