Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEASolution:
This was messy. Eventually able to parse it. The numbers didn't tie for all of the records.
It's important to be able to split the high level columns from the middle ones and then conduct your transformation. There are 17 high level at the start and 3 high level at the end; 8 fields for the child table.
I ran the url in the browser to pull the data, just to view it as well.
A nice challenge for getting familiar with downloading via JSON. Needed help at the beginning for JSON parse and download.
This solution is unique and cannot cross-check with my solution since the downloaded data has been updated.
First time working with JSON in Alteryx. It was a little painful since the data seems to have changed. It looked to me like initially fields were being subtracted from each other. I finally took the solution- output it to a file (minus the weird Field12_xxx at the end since the count didn't match the json input and it was hard to tell which fields they were) and checked it with my answers. I'm calling it solved 🙂