Hi,
I’m looking to generate a dataset containing around 30000 unique usernames based on an 8 digit number, some of which (not all) start with a specific 2 digit number. Can somebody advise on the best way to go about it?
Many thanks,
Have a look at the formula data type. You can use it to combine fields to make a custom type. You could, for example combine the built in username field with a number field to get the desired output. It also has a random() function and if logic so you could randomly switch between formats. Also, any field you name starting with two underscores will be hidden from the output. This is a common practice when composing fields using formulas.