How to set a serial number based on multiple properties

Hello,

I want to set a serial number based on multiple Properties.

I'm trying to set a serial number based on a TEXT type key item, but I'm not getting the expected results. I'm trying to implement this using the RANK Function.
If there is an implementation method, could you please guide me? The "RANK_2" in this diagram is the result I want….

Best regards,

Accepted answers

All comments

PujithaB

Hi @taku. s

This can be achieved as creating a list of all the unique Key and assign code sequentially then use this code for Rank
Let me know if this helps out
Thanks
Pujitha

taku.s

Hi @PujithaB

Thank you for your reply.
Actually, because the key item is over 60 characters, I can't set a Code.
Therefore, I'm creating a key item by concatenating multiple Properties.
I want to create a Serial Number based on that key item.

I appreciate your assistance.

Best regards,

PujithaB

Hi @taku.s

**** Therefore, I'm creating a key item by concatenating multiple Properties **** - Use this lineitem to create a intermediate list named as Key with filtering only Isfirstoccurrence combinations
Create a list with all unique items with name —— Key
Create a Sys module with dimension as Key List
In this module create below lineitems
Name of Lineitem —-Unique Number Formatted as Number with Formulas as RANK(1, ASCENDING, SEQUENTIAL)
Use this Unique Number to import as Code for the Key List
And in the above module try to use finditem to fetch the code for each combination

Let me know if this helps out
Thanks
Pujitha

taku.s

Hi, @PujithaB

Thank you for your response. I understand your advice.

There may be times when the name of the List Item exceeds 60 characters, what should I do in such cases?
I understand that if I change the Key List to a Numbered List, I won't be able to use FINDITEM with the List Item's name.
I'm having trouble because if I format the name of the List Item to be less than 60 characters, there are cases where the names become duplicated.

I appreciate your help.

Best regards,

PujithaB

Hi @taku.s

I understand the scenario here. In this case, When you are creating the Key using concatenation of different parameters, Can you check if you can reduce length of any parameter.
Also, while concatenating different try to check if you can combine codes of any parameters instead of actual list item/text

Let me know if this helps out
Thanks
Pujitha

Quick Links

Can you help?

Unanswered questions

Azure blob connection Cloudworks vs ADO
I am trying to connect to Azure blob, the credentials work on cloudworks, but do not work on ADO. Has anyone else experienced this issue?
Berapa nomor Tokopedia?
Tokopedia Menyediakan layanan WhatsApp? Untuk menghubungi layanan Tokopedia melalui (WA)62_08174_9080_16 kamu bisa mengikuti.
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…