Want to get involved? We're always looking for ideas and content for Weekly Challenges.
The result does not match with the expected output data.
I guess it is due to the site data is updated...
Attaching my solution
Cool exercise to learn some other tools or functions
Here is my solution
I initially struggled a lot with conceptualizing how to separate and bring this data back together. Had to physically talk through how I needed the rows to look before I did any transformation and that helped a lot.
Was going to do a lot more filtering than I needed to. Turns out I just need to separate the column names and rejoin.
Fun first time using JSON!
Here is my solution for the challenge. I am working my way through the Alteryx challenges.