Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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