Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
Start 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 #302: International Bank of Awesome Data - Part I

RobertOdera
13 - Pulsar
‎05-05-2023 07:04 AM

My Solution - Cheers!

Spoiler
RobertOdera_0-1683295408354.png

 

challenge_302.yxzp
Reply
0 Likes
Robinvm
8 - Asteroid
‎06-08-2023 09:32 AM
Spoiler
Robinvm_0-1686241924297.png

 

Challenge_302_Start File (Corrected).yxmd
Reply
0 Likes
boglarkalipka
8 - Asteroid
‎06-09-2023 02:38 AM

solved

Challenge_302_Start File (Corrected)_solved.yxmd
Reply
0 Likes
FilipR
11 - Bolide
‎07-05-2023 05:18 AM

Solved. 

challenge_302_Start File.yxzp
Reply
Swathi
9 - Comet
‎07-06-2023 04:16 AM

PFA for solution

Challenge_302_Start File_Solution_SM.yxmd
Reply
0 Likes
NMangera
11 - Bolide
‎07-17-2023 03:18 AM

 

workfllow.png

takeaway

1.  regex: parse based on # of specific characters expected in each field

2. tool config: '%p' for incoming string fields with 12/24 clock windows

Challenge_302_NM.yxmd
Reply
0 Likes
ciplionej
7 - Meteor
‎07-22-2023 08:40 AM

That was a not a hot mess, it was a fiery mountain of regex hell!

 

Spoiler
302.png
Challenge_302_Start File (Corrected).yxmd
Reply
0 Likes
mithily
8 - Asteroid
‎08-16-2023 06:28 PM
Spoiler
regex rescue
Challenge_302_Start File (Corrected).yxzp
Reply
0 Likes
gawa
16 - Nebula
16 - Nebula
‎08-25-2023 09:06 PM

Done

Challenge_302_Start File (Corrected)_gawa.yxmd
Reply
0 Likes
Rana_Kareem
9 - Comet
‎08-27-2023 07:55 AM
Spoiler
Challenge 302.png

 

Challenge 302 - Solution.yxzp
Reply
0 Likes
Live Weekly Challenge