Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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