We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #349: Analyze the World Cup Event

MichaelfIngham
5 - Atom

Easy peasy. 

 

Spoiler
Probably should have done a reg-ex for the matchup split, but went formula and text to columns instead.

Great weekly challenge.  

Manav_Sehra
8 - Asteroid

My solution is attached. 

Spoiler
Manav_Sehra_0-1671218921423.png

  

 

Dev73
8 - Asteroid

My Solution

johanna_joso
5 - Atom

Done

rmassambane
10 - Fireball

349!

alfard305
5 - Atom

hi! newbie here. do tell me what tool those yellow equal signs are. i did try downloading your solution to check but upon opening the workflow, what I got were black question marks with the error, " The entry point is invalid."

AkimasaKajitani
17 - Castor
17 - Castor

Hi @alfard305 

 

The yellow tool is Expected Equal macro which is in CReW Macro Pack.

Please download it from the URL below.

http://www.chaosreignswithin.com/p/macros.html

 

kristiadiuisan
8 - Asteroid

Done it using 10 tools

Dantastic
8 - Asteroid

solved

Pete_Rodgers
Alteryx
Alteryx
Spoiler

could have been a regex... but time pressure, slipped into Excel logic pattern

Pete_Rodgers_0-1671462283336.png