Challenge #69: Web Stock Data

[meetpuru]

69_Soln

[Bonero]

my solution

[eric_strein]

Solution attached.

Spoiler

[jtwmoore]

Fun one!

Spoiler

[cc000072]

Here is my solution.

Spoiler

[jdbaldwin]

I don't understand why the posted solution bothers to split with that filter; just adding new sequence numbers and cross-tabbing back does the job.

I tossed out the HTML bit and added 100 records in a text box just for demo/test purposes.

Spoiler

Solution posted below.

[Tberney]

I confess I'm confused by all the transposing and crosstabbing in the proposed provided solution. All it seems to do is leave all the fields enormous. A simple Dynamic Rename (for the column headers) and Auto Field (to adjust the field sizes, and in particular the boolean types) seems to do the trick one the file is parsed. Am I missing something?

Spoiler

[JKCecil]

Bummed it isn't not stock data (:. Mushroom data successfully downloaded and modification of Bruise column data completed.

[Ross_Easton]

Solved

Spoiler

 

[JohanRanschaert]

Spoiler

In attach my solution