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!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

abbyabbypoon
8 - Asteroid
‎11-01-2024 09:56 AM
Spoiler
443.png
Reply
0 Likes
briantowner
5 - Atom
‎11-01-2024 01:02 PM
Spoiler
443 Solution.png
443 Output.png
 

 

 

Challenge_443.yxmd
Reply
0 Likes
GDickinson
5 - Atom
‎11-04-2024 01:12 PM

 

Spoiler
A solution with a simple regex replace

 

 

Challenge_443_solution_file_GD.yxmd
Reply
0 Likes
Albert_Vega
8 - Asteroid
‎11-04-2024 01:50 PM
Spoiler
2024-11-04_14-48-35.png
Challenge_443_start_file.yxzp
Reply
0 Likes
mbens123
7 - Meteor
‎11-05-2024 11:50 AM
Spoiler
Screenshot 2024-11-05 443.png
Challenge_443_mbens123.yxzp
Reply
0 Likes
lwolfie
11 - Bolide
‎11-07-2024 07:31 AM

it works...:)

Challenge_443_solution_LW.yxmd
Reply
0 Likes
EuanGriffith
7 - Meteor
‎11-11-2024 05:30 AM

Great, taught me something new!

Spoiler
443 Complete.png

 

Challenge 443 Solved.yxmd
Reply
0 Likes
zb12
5 - Atom
‎11-12-2024 08:21 AM
Spoiler

Formula tool:

ConvertFromCodePage([Item Number], 65001)

 

Data Cleanse tool

 

Join tool

Challenge_443_start_file.yxmd
Reply
0 Likes
cfowler
5 - Atom
‎11-12-2024 08:53 AM
Spoiler
solution_CFowler.png

 

Challenge_443_CFowler.yxmd
Reply
0 Likes
Christina_H
14 - Magnetar
‎11-19-2024 06:26 AM

Interesting one!  My solution:

Spoiler
image.png
Challenge_443_CH.yxmd
Reply
0 Likes