Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #69: Web Stock Data

Walsh67
8 - Asteroid
 
JoBen
11 - Bolide

Cheers!

pasccout
8 - Asteroid

Here is my solution... one for the fields from the provided results (Bruises) shows True & False... Not sure if we needed to parse it or not...

 

 

catherineduffy
8 - Asteroid

My solution: 

 

Spoiler
challenge_69.jpg
Laurap1228
11 - Bolide

My solution to the Mushroom Challenge:

Spoiler
Challenge 69.jpg
MarMu
8 - Asteroid

 

Neat challenge

 

The task is seemingly pretty straight forward however two observations.

1) I wanted to make the no. of columns dynamic for safe guarding (and fun).

2) When you Cross Tab you automatically sort field order alphabetically. I first thought was to filter out first row and join as header and then Cross Tab, but that will also implicitly order column names.

 

Ipso facto I ended up with this bad boy of a workflow. And yes, I left the cache on to brag about this new cool feature. saved me many seconds :P

 

Spoiler
challenge_69_start_file_MarMu.png
jssandom
8 - Asteroid

Enjoyed learning to use Download tool for the first time!

KMiller
8 - Asteroid
 
KMiller
8 - Asteroid

Solution attached.

justynam
8 - Asteroid

My solution