Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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