Selecting elements from arrays in dataset

#1

Absolutely fabulous product. Don’t need the download volume, but just upgraded to the Silver plan because I think this might be the most helpful thing I’ve stumbled across and you deserve it. I used to do this stuff by hand. :frowning:

I’m trying to look up a value in a row in a JsonArray inside another dataset.

So my account json object has an array of payment profiles in it. I want to create a user dataset that has one of the id numbers from the array of account payment profiles.

I know I can select the entire array, but how do I access just a field inside the array in another dataset?

Can I randomly index the joined data in a "from_dataset statement?

TIA

Bill

#2

Thanks, Bill!

Currently CSV is the only format supported by datasets. Can you extra the payment profile data into a csv file offline and upload it back into Mockaroo as a dataset?

Also, if you post the share link at the bottom of your schema I might be able to gain some more insight.

#3

Hadn’t occurred to me to use an unrelated file to associate the items. Let me try that. This ends up looking a bit like a many to many relationship.