Full name repeating %

#1

Hi,
Where do I control frequency of the appearance?
in the Frequency datatype I dont see numeric values.

For example
Full Name , longitude , latitude, birthday
Josh Smith , 37.45, 9.01667, 10/10/1970
Josh Smith , 37.45, 9.01667,10/10/1970
Josh Smith, 37.45,9.01667,10/10/1970
Barbara Smith, 127.66528,34.76278,11/11/1975
Barbara Smith, 127.66528,34.76278,11/11/1975
Bill Smith, 127.66528,34.76278,12/12/1980

Let say we will have thousands of unique names.

Thanks,
Michael

#2

Based on a quick check of the frequency field, that’s not what it does. Have you tried to use a custom formula to generate names at given percent of the time? You might be able to use a given dataset if you know the names you would like to use.

#3

You can add a frequency column and upload the data as a dataset. See “Controlling Distributions” here: http://mockaroo.com/lists/new

#4

Is there a way to get repetitive phone numbers (for eg : I need 10 phone numbers to be repeated 20 times ) while downloading the data itself rather than uploading a dataset with frequency field?
Please let me know.

#5

You can use a Custom List field with either a sequential or custom distribution.

#6

Can you please explain more? How to use Custom List field with either a sequential or custom distribution?

#7

See http://mockaroo.com/759da9d0

Here I use a list of 10 phone numbers with the sequential distribution to generate 200 rows of data. When you use the sequential distribution, it iterates through the list from start to finish and then repeats. Thus you’ll get exactly 20 repeats of each phone number in the resulting dataset. If you chose the random distribution type, you would get roughly 20 repeats of each, but the exact number would be different each time. If you want to weight some numbers more than others, use a custom distribution.

#8

Thanks it works, but unfortunately country code for this particular phone number does not match when I use custom list.
for eg:
phone number = + 44 465 165 3879
country code is supposed to be GB , but country code appears as US .

If I dont use custom list , country code appears correct. How to resolve it? Please help me out.

#9

Custom List just uses the values you give it. So one of the values must be wrong.

#10

I am using columns “country code”, “state code” ,“phone number” . The country and state code must reflect values respective to phone number. But the correct values in the country and state code are not displaying

example =

phone number country code state code

  • 44 465 165 3879 US KY
  • 44 465 165 3879 US FL
  • 1 205 188 8317 GB ENG

First 2 records should have country code as “GB” since it starts from +44 and third row should be US since the phone number stars from +1

Please let me know how to tackle it?

#11

In that case you need to upload all 3 columns as a single Dataset, then pull those columns into your schema using the Dataset Column type. You can’t use Custom List because you’ll lose the correlation between columns.

#12

Thanks a lot for your help