Genereting a unique id from a uniqe string

Follow

Tugrul Bayrak

• December 06, 2018 08:40

Hi,

I have an id column with 32 alphanumeric characters. I would like to produce a smaller unique integer ids. How can I achieve this on datameer? 

Thanks 

0

• 

  Alan

  • December 06, 2018 17:08

  Hi Tugrul,

  Create a copy of your worksheet.  Then, add two columns to the left side of the new sheet.

  In the first column put GROUPBY(1) in the formula bar, then in the second column put GROUPROWNUMBER() into the formula bar.

  For more information see our knowledge base article on assigning a unique id to a group: https://datameer.zendesk.com/hc/en-us/articles/212971463-How-to-Assign-a-Unique-Number-ID-to-a-Group

  0

  Comment actions Permalink

Please sign in to leave a comment.