Keeping values consistent if values overlap in another field

#1

Hello,

I have a problem where one field is “individual ID”. Individual ID has some duplicates, with IDs appearing between 1 and 4 times. I have another field called “ethnicity” which is currently a custom weighted list.

The trouble is, right now the same individual has different ethnicities in different rows. How can I make sure that each individual has consistent demographic data, regardless of how many rows they repeat in?

Thanks!

#2

Use the same practice you would apply in a database: normalize. Generate a dataset of Individual IDs and ethnicities, then pull those values into your schema using the Dataset Column type. Mockaroo will automatically pull each column from the same row to keep data correlated.