Auto generation of Code

Sai_Bharadwaj_Venati
edited December 2022 in Modeling

Hi everyone,

We have list of Activities that are being uploaded in a numbered list with Activity Description and Expense Group as Unique Properties. Requirement is to generate Code in Anaplan based on Activity. I've tried different approaches but not able to fulfill all criteria

Example: -

Activity DescExpense GroupAnaplan Code
ABCTravelA1-ABC
XYZITA2-XYZ
ABCITA1-ABC

V.Sai Bharadwaj

Connect on LinkedIn

Best Answer

  • Sai_Bharadwaj_Venati
    edited December 2022 Answer ✓

    Approach we've taken to solve the problem: -

    1. Instead of creating code at Activity-GL we have created code at Activity level. This takes care of the duplication issue

    2. Used finditem to get the Activity code in Activity-GL list

    3. Concatenated with GL

    we are using Activity as parent of Activity-GL

    V.Sai Bharadwaj

    Connect on LinkedIn

Answers