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

Challenge #45: Parsing Bureau of Labor Data

TraceyD
Alteryx Alumni (Retired)

Not sure the solution workflow matches the solution output in the starter file - one has 600 recs and one has 1200 recs...

seinchyiwoo
Alteryx Alumni (Retired)

my solution:

Spoiler
seinchyiwoo_0-1611651387006.png

 

robert-headington
8 - Asteroid

#45

clmc9601
13 - Pulsar
13 - Pulsar

My solution

Hub119
8 - Asteroid

Solution attached.

apathetichell
18 - Pollux

Multi-rows and Regex...

aiahwieder
8 - Asteroid

So much good practice here! Pretty sure I got it, though the dataset is new . . .

JP_SDAK
8 - Asteroid

My solution seemed rather long, but it worked.  Curious to see how others did it. I cached the download and it went WAY faster after that.

Spoiler
JP_SDAK_0-1615265500594.png

 

BeginnerMindset
8 - Asteroid

Great challenge.

Spoiler
BeginnerMindset_0-1615311007395.png

 

LHolmes
9 - Comet

New data, same result structure. Fun challenge!

 

Spoiler
045 - Solution.PNG