Unique 6 digit ID

[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.