community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #69: Web Stock Data

Highlighted
Asteroid

Hi! Here my solution :)

I liked it very much!

Alteryx Certified Partner

My solution

Quasar

Solution:

 

Spoiler
Capture.PNG

Attached is mine. I enjoyed this one.

Asteroid

my solution

Spoiler
Challenge 69 Spoiler.PNG
Alteryx Partner

My solution.

Alteryx Partner

This was made immeasurably nicer to do thanks to caching :)

 

Spoiler
challenge 69.PNG

I've attached my solution!

Alteryx Partner

Uh I do love a good web scrape 😃

 

So here is my solution

 

 

Spoiler
Pretty straight forward I think.
1) Get the data
2) Split the fetched data into rows
3) Then split into columns
4) Select the relevant columns
5) Dynamic rename the columns from the first line of data
6) Minimize the data types by using Auto Field

Voila
2019-02-20 11_39_54-Alteryx Designer x64 - challenge_69_start_file.yxmd_.png

 

Still Climbing

/Thomas

Meteor