Mapping Data Based on Combination of Codes/Number
I would like to hear your idea or case regarding the topic.
What needs to be build is to map the code based on combination of codes/number (please refer to the attached image that describe mapping logic table).
I can create such logic but too much complicated to maintain(Use tons of IF, LEFT, and such).
The table is changed every quarter so that I would like to create the logic in Anaplan as simple as possible.
Do you have any idea or cases that you can share with me regarding that?
If you have any questions, please let me know.