Challenge #69: Web Stock Data

[mascarenhas_lucas]

Follows my solution! Different from the oficial solution, my solution only works if you know the number of columns from the .csv file.

Spoiler

[kcgreen]

Done

Spoiler

[daniel_ferreira]

Follow my solution attached...

[StevenBetts]

Here's my solution to the challenge :)

[elizabethshevock]

Pavel_G

Would you please post your workflow? Would love to replicate with different tickers. 

[AndyBate]

complete

[mceleavey]

Mine is probably the same as most on here. 

Spoiler

I tokenised each line to a row using regex, then split out the columns using a text to columns tool. Then I simply used dynamic rename to take the headings from the first row, then used a formula to correct the bruises columns. Simple.

[mickael_gest]

My solution :)

Nice challenge !

[JonM]

Spoiler

I love how easy it is to bring in these external data sources! forever surprises my work colleagues!

[dsmdavid]

I took it as a parse problem.

Spoiler