Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
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 #433: Ogden’s Basic English – Making Words Count

alexnajm
17 - Castor
17 - Castor

A little bit of exploration necessary, but we got there in the end... barring the G&P differences like everyone else.

Spoiler
Challenge 433.png
kelvin_law1
9 - Comet

Here is my solution:

Spoiler
433.png

I couldn't get my answer same as the output for G and P, but I think my workflow is correct😁

ARussell34
8 - Asteroid

Here is my count of Ogden's words!

 

AR_433.png

 

Dev73
8 - Asteroid

Great challenge challenge 433.jpg

olga_strubbe
11 - Bolide

Thank you, @Tokimatsu, for a great RegEx challenge!  I love Regex - well, put it this way, most of the time when it works :) 

I followed a similar approach to @TurboToad  in solving this challenge - thank you @TurboToad for RegEx Tokenize formula tip!

Capture.PNG

 

 

Shelbey
Alteryx
Alteryx
Spoiler
Screenshot 2024-07-22 094457.png
tammybrown_tds
9 - Comet

My "G" and "P" are both off by one, but I think it's formatting in the hyperlink that I ran out of time to diagnose.

 

Spoiler
Screenshot 2024-07-23 163858.png
PaulGriffiths
7 - Meteor
Spoiler
Challenge 433.png

 (Have I cheated by removing the rows at the top and bottom that aren't part of the word list using a select records tool?)

MitchyMitch
8 - Asteroid

Always a good time when I get to use the RegEx tool! :) Found a discrepancy in the output with the count from P & G. Each returned one count short from the expected output. Double checked the website and my count is correct, so could be that an edit took place some time in-between. 

Spoiler
Challenge 433.png
martin-krejci
7 - Meteor
Spoiler
2024-07-25-Alteryx Designer x64 - Challenge_433_start_file.yxmd.png