Unique 6 digit ID

[nick.soan]

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?

[mp_np]

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

Uniqueness of generated values

No, general Mockaroo data is random, with no guarantee or effort towards uniqueness. Uniqueness is very hard to accomplish at scale. Mockaroo uses multiple concurrent processes to generate large scale datasets quickly. That architecture does not lend itself to guaranteeing uniqueness because the processes work independently.

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.