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.
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?