We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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 #151: Meta Parsing

peter_gb
10 - Fireball

Nice, I immediately went macro but could have been simpler, also couldn't really be bothered to faff with the column order but note others' solutions and persistence to do so!

Spoiler
challenge_151_pgb.png

JamesCharnley
13 - Pulsar
Spoiler

JamesCharnley_1-1659823979145.png

For some reason it had never crossed my mind that you could update a string formula like that until I just tried it!

Brian32
8 - Asteroid

Challenge Solution:

Spoiler
Brian32_0-1660927680697.png

 

nandagaikwad03
8 - Asteroid
Spoiler
Challenge_151_Workflow.png

grazitti_sapna
17 - Castor

workflow

 

grazitti_sapna_1-1662007600698.png

 

 

 

Macro

grazitti_sapna_0-1662007566603.png

 

Sapna Gupta
MilindG
12 - Quasar
Spoiler
MilindG_0-1662065691959.png

 

tammybrown_tds
9 - Comet
Spoiler
tammybrown_tds_0-1663796139733.png

 

Spoiler
tammybrown_tds_1-1663796158840.png

 

 

Liusaidhowen
8 - Asteroid

My solution

acarter881
12 - Quasar

Here's my solution. The standard macro contains similar tools.

Spoiler
my_weekly_challenge_151_solution.png
karlhansen
9 - Comet
Spoiler
solution_151.jpg