Code Generation on duplicate information entered by users.

Hey Folks, I am trying to generate code in the module in which user list is already applied, due to request from the team I want if the same information is entered by the user1 and use2 it should update the counter accordingly surpassing the users. for ex. if I have user 1 entered information as "abc" so the generated code would be "abc1", now if have user 2 entering same information "abc" so the code for that should be "abc2" and not "abc1". If there is any way possible do let me know. Attaching screenshot(examples) for reference.

Thanks, Anmol Sarna

Picture_2_137448.png

Picture_1_137448.png

Accepted answers

Nagaraju

Hi, please follow the below steps:

Create line item Rank User. Here we shall Rank User list.
Next step is to use RANKCUMULATE and cumulate the user ranks by group (input by user).
Create Final Code by appending the Input and rank number generated by RANKCUMULATE in previous step.

Attaching the module and blueprint images:

Hope this helps!

All comments

ManjunathKN

Hi Anmol,

you can have a system module with users and numbered line item. you can give sequential numbers to all users in system module. in target module, you can bring the numbered line item, when user enters the text code, you can concatenate the text and numbered line item(use text() to convert into text) and generate code.

Thanks,
Manjunath

anmol1111

Hi @ManjunathKN ,

Thanks for the solution but how is it checking for duplicity since I wanted to generate code "abc2" for "abc" information entered by user 2 if "abc" information is already been set by user 1. I want code generation on the basis of information entered surpassing the users.

Thanks,

Anmol Sarna

Nagaraju

Hi, please follow the below steps:

Create line item Rank User. Here we shall Rank User list.
Next step is to use RANKCUMULATE and cumulate the user ranks by group (input by user).
Create Final Code by appending the Input and rank number generated by RANKCUMULATE in previous step.

Attaching the module and blueprint images:

Hope this helps!

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled