FINDITEM(Manipulation)

Hello All,

I have a situation where I need to do a FINDITEM on a bit different situation.

I have one list called Org with codes such as 1001_AX_501, 1002_BX_503, etc.

Other list called CC with the same set of members, however, the codes are 1001, 1002.

In order to map them, I need to do a FINDITEM with some twist so that the items in the long code after the 1001, 1002 (ie the underscore and all) can be ignored.

How do I achieve this?

Thanks

Accepted answers

All comments

Soumik1947

In order to achieve this we first need to extract the required code from Org code for CC(considering this will be always 4 digit) then we have to use that code to search for CC. Please check the screenshots attached if that is what you are looking to implement.

pyrypeura

and if your cc code is not always 4 digits you can also use find to get that dynamic. Below are screenshots where find is used to control length of CC code.

Br,
Pyry

khoonks

Hi thanks,

I was able to take this approach yesterday, however, not able to do the other way round.

Trying FINDITEM, but not working.

If you had to do just the opposite, where the short code would be on the left as the list and the long code would be as line item, what would you do? thanks

pyrypeura

Hi,

If you have cost center code how would you determine end part of your long code?

CommunityMember131103

Are your Org with code are always unique for every cc codes ?

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…