Forum Discussion

Bilal_321321's avatar
Bilal_321321
Helper I
7 years ago
Solved

Unique ID for GUI's

Hi All,

 

I need help with a formula to assign a unique number to a list of ID's. The table below shows what I am trying to do:

 

 

My mind is running a blank and I can't think of the correct search terms. Any help would be appraciated

Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Bilal_321321 

     

    Using Query Editor>>select column GUI>transform tab>Group by

    then do as follows

     

     

    Now add an index column

    Now expand the all column to new rows

1 Reply

  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    Community Champion
    7 years ago

    Bilal_321321 

     

    Using Query Editor>>select column GUI>transform tab>Group by

    then do as follows

     

     

    Now add an index column

    Now expand the all column to new rows