How to set a serial number based on multiple properties

Options

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,

Answers

  • PujithaB
    Options

    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
    edited June 5
    Options

    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
    edited June 5
    Options

    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
    Options

    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
    Options

    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