How to set a serial number based on multiple properties

taku.s

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,

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