Challenge #69: Web Stock Data

[Kakuffo]

Two Solutions here

One dealing with field headers seperate from the main data than stacking data using union

The second is 6 tools in total and a much more efficient route

[mikeprice17]

I feel like they added unnecessary steps in their solution. 

[ChuyVBabs]

A little Alteryx magic sprinkled on shrooms.

[MattBenj]

I'm using this as an example for some new Alteryx users in our company. 

Spoiler

Finally found a good example of when to uncheck the *Unknown box in the select tool.

[Nicholas_Bignell]

https://youtu.be/xu6mDGq8e7o

[ZenonH]

Took a bit to realize there was also line delimiters /n, otherwise quick and fun. 

Spoiler

[PeterH23]

This was a good one!

Spoiler

First tried using Cross tab, but had trouble with the column names being renamed (non-alpha hyphens changed to use underscores). Found a great post from @MarqueeCrew with an example using Dynamic Column Rename. That really helped - Thanks!

[dashakir1]

Thanks MattD.