Unique 6 digit ID

Hi all,

I am trying to create a “UserID” column that needs to be numeric and exactly 6 chars in length ( so 100000 to 999999). I have created a number column and put the min as 100000 and the max as 999999 with 0 decimals and produced 100,000 rows. A few seconds into loading the data into my database I get an error stating that it cant insert a duplicate row. Is there a way to make the numbers distinct?

Hi @nick.soan - I don’t think it is possible to generate unique records. See this post here:

You could possibly create your own dataset, ensuring no duplicates, and pull from that sequentially, or use the row number as part of a formula to ensure it is unique.

2 Likes