Challenge #69: Web Stock Data

[AndrewS]

#69

[ken_yap_au]

Done. 

[SueDonim]

Again, a helpful exercise (and the YouTube videos on various tools also help....)

What I learned:

- Lots of hidden tools in Alteryx.  I need to figure out where to find them and add them to my Toolbar (rather than search one at a time)

- Grabbing and parsing csv files is simple - now I just have to figure out how to find them on a website (and then how to cycle through to capture all of them)

Spoiler

By the way, I am noting process here (and in other challenges) for my own records and eventually for others to reference once I become knowledgeable enough that anyone would care about my answer (but today is not that day....)

Process:
- Download file using Download tool
- Separate file into rows (using \n delimiter)
- Separate file into columns (using , delimiter)
- Rename fields with Dynamic Rename tool (selecting use first row as field name setting)
- Swapped "True" for "t"
- Deleted unneeded columns
- Check results with Expect Equal tool (from Marquee Crew)

[mhgarcia]

Solved

[kmalone007]

Solution

[blundebjerg]

Here is my solution

[MargaritaW]

This is the mushroom challenge. I added a batch macro to avoid manually setting the number of columns for splitting the data.

[justindavis]

Spoiler

"They're mushrooms - they don't get that high." - Dwight K. Schrute

[jagdeep_singh85]

PFA my solution