Challenge #45: Parsing Bureau of Labor Data

[The_Rad_Valentina]

This needs an updated link so that it will work with a download tool. Otherwise this is just a different type of exercise. 

[Yoshiro_Fujimori]

My solution.

As the URL is changed, I am not sure if this is the same solution as the original challenge.

Spoiler

Download tool was used to get .xlsx file.

The remaining workflow needs to be kicked after the download completes.

[ntakeda]

My solution.

[BS_THE_ANALYST]

@Towers helped me with the Wayback machine URL! 

Also: Dynamic Solution.

[Towers]

quite a challenging one, I had to use the Wayback machine to obtain the link to the data. I enjoyed it though! 

Spoiler

 

[mithily]

Spoiler

Used the provided file from another user since the original link does not work; dynamic renames and splits

[jennifer_owens]

Learned a lot on this one. 

https://web.archive.org/web/20160801000000*/https://www.bls.gov/web/empsit/compaes.txt

Go back in time to grab data since the link does not work! 

[jennifer_owens]

Forgot the remove the "p"s!  Updated here. 

[H_a_n_g_C_h_e_n__x3]

The link did not work. Used a source file and made a macro instead. No way to check for Accuracy as the Dates are off. 

[jon_amanrich]

Realised that I made my life more complicated than necessary here 😅