Make copies of an entry in a JSON Array for other JSON Arrays

#1

In my schema I have 5 ‘JSON Arrays’, each with different fields, with all of the arrays needing to have the same ID as the first field. I generate a random ID for the first field in the first array, but want to use that same generated value in each of the first fields of each array. How would I implement this?

#2

You could use a formula to reference an id field outside of the arrays. Here is an example: http://mockaroo.com/1def1210. You can change the name of the id field to “__id” if you don’t want to include it in the output.

#3

Thanks for the quick and easy response!

#4

One quick follow up, using the same schema above. The types ‘Street Number’ and ‘Street Address’ don’t correlate. I use one in one array and the other in another, and I want them to be the same. I’m thinking that a substring is the way to do this but the number in street address could be any length between 1-5. Any way for me to take a substring until the first ‘space’?

#5

You can use a formula: street_address.split(’ ').first

1 Like