generating sequential numbers

Faezehmehranfar
Faezehmehranfar
in Academy Discussions

Hi everyone!

I have a numbered list that has code as a property ( when importing i use combination of properties to create this list items ) . and there are items that has same codes and names. but same items have different BCs.

image.png

for showing that which BCs belong to which item, we create a module using an index list and another list that shows unique items of the main list.

image.png

now for this purpose, we need to generate sequential numbers to items of first list that have same codes and names. so we can use use this numbers for mapping. sequential numbers should be like picture below

image.png

how do you think we can solve this problem?

Answers

  • ShubhamCh
    ShubhamCh

    Hi @Faezehmehranfar

    Create one list 'Unique Codes' with all the unique codes {A, B, C….}

    In SYS module, create one FindItem line item which will find items in Unique Codes list based on Code (Property) then simply use Rank formula :-

    image.png
    image.png
    image.png

    I hope it helps.

    Thanks!

    -Shubham

  • Faezehmehranfar
    Faezehmehranfar

    @ShubhamCh thank you very much for the help, great solution!

Categories