Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語

IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Looked for similar data as the link is broken (As stated by others) There is an excel file circulating that some have used. This is what I used, seemed to be missing some information but still was a test of parsing skills.

Multiple tables into one table

Challenge 45 WF Image.png

Challenge 45 WF Image.png

Had to use the excel file to make this work even the archive link people posted wasn't working. So, not sure how close this is to the work required in the past since I'm not sure what parsing was needed.

Thanks for those who shared the excel file (Attached below)

Screenshot 2023-08-19 154847.png

185 KB

Link was invalid so used alternative source

Solution attached

Done

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/

The URL is not working. Is there any alternate URL that is available??.

this link to data "http://www.bls.gov/web/empsit/compaes.txt" is broken; so instead I used this one: "https://www.bls.gov/web/ecec/ececqrtn.txt"

I did something similar breaking the title part into sections

and then creating a table from the first dataset.

A lot of TextToColumns and Cleansing tools used. The TABs are a doozy!

I saw that too. I found this instead to work with - same premise; chop up a data file!

"https://www.bls.gov/web/ecec/ececqrtn.txt"

My solution below - I used the shared XLSX file version of the updated dataset