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 #443: Mystery of the Unjoined Records

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
Hub119
11 - Bolide
11 - Bolide

My solution:

Spoiler
Challenge 443 Pic.png
ARussell34
8 - Asteroid

Just a quick data cleanse and select tool to get the two files to join.

AR_443.png

alexnajm
18 - Pollux
18 - Pollux

All too familiar.... drives me crazy!

Spoiler
Challenge 443.png
mmontgomery
11 - Bolide
11 - Bolide

C443. More in spoiler\

Spoiler
Took a minute to think about approach, and went with: "What do I want to include only" instead of "let me exclude a,b,c, etc". Came away with this regex expression to only include numbers or letters and it worked: REGEX_Replace([Item Number],'[^\d\w]','')c443.png
nSpire
9 - Comet
Spoiler
443.png

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

My solution.

Spoiler
Workflow
Challenge_443_workflow.png
Expression
  Item Number = REGEX_Replace([Item Number], "[^\w]", "")
Qiu
21 - Polaris
21 - Polaris

This challenge made me doubt about my sight... 😂

Spoiler
challenge_443.PNG
balajilolla2
10 - Fireball
Spoiler
Solution Attached
Alteryx Challenge.jpg
Caramel8
7 - Meteor
Spoiler
2024-09-23 20_47_22-Alteryx Designer x64 - Challenge_443_start_file.yxmd_.pngtried regex in vain.