Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #7: Download Data and Parse JSON

Highlighted
7 - Meteor

I relied heavily on formulas, and it's a bit clunky, but it matches :-)

Highlighted
Alteryx Certified Partner

My solution :)

Highlighted
8 - Asteroid

Could not get the parse tool (as in the original solution) to split out the Row and Sub rows and assign int so had to use another text to columns >:( nonetheless solution attached

Highlighted
7 - Meteor

Challenge #7: Solution

Alteryx Partner

still not regex-ing and had to have a peek at the solution to figure out how to get the pivoting to work...

 

Spoiler
7 json parse.png
Highlighted
8 - Asteroid

Here is my solution... really wish the crosstab would not rename column headers with _

 

Highlighted
Alteryx Certified Partner

This has been the toughest challenge for me so far, and I will have to admit that I have spend quite some time on this, since I did got stuck.

 

My solution clearly falls into the catogory, that shows, that in Alteryx there is many ways to get to the same end result.

 

I am not happy with my solution, but my result matched up with the provided output, and here it is

 

Spoiler
So it turned out, it was not the JSON part that was the hardest, but the further transpose and cross-tab'ing  of the data.
I did use the new cache feature of 2018.3, so I did not had to hammer on the API to get the data every time I had to re-run the workflow.
My take on JSON parsingMy take on JSON parsing

I will most definable take a look at the other solutions provided (especially #1 @NicoleJohnson 😄), so I can get wiser.

 

 

 

//Thomas

 

Highlighted
Alteryx Partner

Cool to use APIs and more parsing!

Highlighted
Alteryx Certified Partner

A really interesting challenge!

 

Spoiler
Challenge 7.PNG
Highlighted
8 - Asteroid