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

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

Hi Community,

 

A solution to last week’s challenge can be found here. This week’s challenge was submitted by Alteryx ACE and Grand Prix champion, Claire McCollough! Thank you, Claire (@clmc9601), for this exciting challenge submission!

 

Can you solve the mystery of the unjoined records?

As part of a performance analysis, you have two datasets: one containing the Item Number and Item Cost, and another containing Item Number and Product Type. Your task is to get the Item Number, Item Cost, and Product Type all in the same table.

 

Although it looks like a simple Join tool would do the trick, for some reason, the rows do not join correctly. You need to determine the extra steps you need to take to make the join work.

 

Tips:

  • Modifying the input YXDB files or retyping the data is NOT a valid answer. Your solution should use Alteryx Designer tools and work even if you have hundreds or thousands of items.
  • All five records should join upon output. For the correct answer, none of the Item Numbers should contain leading or trailing spaces or invisible whitespace.
  • If you get stuck, feel free to open the hints provided in the Start workflow.

Source:

You can visit https://www.babelstone.co.uk/Unicode/whatisit.html to identify the Unicode IDs for the invisible whitespace characters.

 

Need a refresher? Review the following lessons in Academy to gear up:

 

Good luck!

 

Academy Team

binuacs
20 - Arcturus
Spoiler
image.png
alacoume
9 - Comet

My solution: 

Spoiler
Challenge_443.jpg
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
443.jpg
Tofel
8 - Asteroid
Spoiler
Interesting ! Never heard of POPDF !

Challenge 443.jpg

mrai02
7 - Meteor
Spoiler
Screenshot 2024-09-23 200637.png

A bit tricky at first but the website helped in finding the invisible characters in the input file.
Awesome exercise.

MelGibson
8 - Asteroid

Oh my gosh - I can't believe this through me for a loop. At first glance it should be easy. 

Spoiler
Challenge 443.png

Erin
10 - Fireball
Spoiler
RegEx to the rescue! The site from the hint is blocked at my office so I'll always have to wonder what mysterious characters I chopped from the text....
JeffersonB
5 - Atom
 

The 'Formula' tool is used to apply the 'DecomposeUnicodeForMatch()' function, ensuring that any hidden Unicode characters, including invisible whitespaces, are normalized.

 

 

olga_strubbe
11 - Bolide

Very tricky, thank you Claire @clmc9601

2024-09-23_10-58-22.png