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

Thableaus
17 - Castor
17 - Castor

Challenge #69, done.

 

Spoiler
I did it in 2 ways. First one (which is on the pic below) is the lazy one 
The second is the right one, where I can do it dynamically - that means, it doesn't matter if a new column shows up or a column is excluded from the dataset.

Challenge_69.PNG

Cheers,

erick_irigoyen
Alteryx Alumni (Retired)

Solution attached. I ended up using data cleansing, download, and dynamic input.

piotrzawistowski
8 - Asteroid

Hi, my solution.

garthn555
8 - Asteroid
Spoiler
gn_challenge_69.png
gautamsawant93
7 - Meteor

Learned a lot on this challenge, mostly followed the model solution. Here's my workflow.

klyuka
8 - Asteroid

Useful task in my dayly work.

JamesHa
Alteryx Alumni (Retired)
Spoiler
Capture.PNG
James Dolan-Hall | Principal Technical Account Manager
support@alteryx.com | community.alteryx.com
joshuaburkhow
ACE Emeritus
ACE Emeritus
 
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
Rahma
7 - Meteor

Solution using three tools. 

 

RWvanLeeuwen
11 - Bolide

My solution:

Spoiler
Download tool -> Parse to rows on new line -> Parse to Columns on comma -> Field rename using first row -> clean-up

Spoiler
69.png