In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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

tammybrown_tds
9 - Comet
Spoiler
tammybrown_tds_0-1602803274879.png

 

Sylvana
8 - Asteroid

My solution. Just using "Text to Columns":

Spoiler
Sylvana_0-1602837108998.png

 

A2H
11 - Bolide
Spoiler
Capture d’écran, le 2020-10-23 à 21.08.15.png
kaianderson
8 - Asteroid

I learned something new with this one.

The switch function is very cool.

joshbennett
11 - Bolide
11 - Bolide

Here is my solution!

 

 

mollyhatch
8 - Asteroid
Spoiler
69 Picture.PNG

 

kmedici
8 - Asteroid
Spoiler
kmedici_0-1606841293486.png

 

Scythe80
6 - Meteoroid
Spoiler
YAC191185_0-1606843743925.png

Not too much different from what I have seen from others. I needed to refer to one person's solution for the initial Text to Columns though. Can someone explain how the "\n" works as a delimiter in text to columns? I didn't notice it within the extract, and would never have thought to use it.

dicky5150
8 - Asteroid
Spoiler
Challenge 69.jpg
beccat
8 - Asteroid

My solution.