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 #237: Wareki

JP_SDAK
8 - Asteroid
‎01-20-2021 08:39 PM

This took a while to get the macro to work - good practice with Detours.

Spoiler
JP_SDAK_1-1611203851580.png
JP_SDAK_0-1611203813526.png

 

 

 

challenge_237_start_file.yxwz
Reply
0 Likes
mhey01
7 - Meteor
‎01-25-2021 07:10 AM

Solved 🙂

 

Spoiler
237_results.png237_macro.PNG
challenge_237_solution.yxzp
Reply
0 Likes
mike_w
8 - Asteroid
‎01-25-2021 11:19 AM

I also added the option of providing your own Date or Wareki. It'll be added to the results, respectively.

Spoiler
mike_w_0-1611602292832.png

 

challenge_237_mrm.yxwz
Reply
0 Likes
robert-headington
8 - Asteroid
‎01-31-2021 03:02 AM

Built the macro so it can take any field and convert it into the other date

challenge_237_RH_solution.yxzp
Reply
0 Likes
apathetichell
20 - Arcturus
‎02-03-2021 08:35 PM

Converting from Wareki to standard seemed to go much slower than converting from standard to Wareki - despite the overwrought nested IF/THEN/ELSEIFs for the date range comparison...

challenge_237_solution.yxmd
237 batch macro.yxmc
Reply
0 Likes
TraceyD
Alteryx Alumni (Retired)
‎02-05-2021 01:54 PM

An excellent challenge!  Here's my solution.

TraceyD237.yxzp
Reply
0 Likes
rcarog
8 - Asteroid
‎02-25-2021 01:23 PM

Solution attached.

challenge_237_solution.yxzp
Reply
0 Likes
MattBenj
10 - Fireball
‎02-26-2021 08:02 AM

It's great to see the variety of solutions this week.

challenge_237_michmatt.yxmd
Reply
0 Likes
lewanark
8 - Asteroid
‎03-31-2021 07:46 AM
Spoiler
lewanark_0-1617201911604.png

 

nice challenge 🙂

challenge_237_lewanark_solution.yxmc
Reply
0 Likes
mdsalmankhan89
8 - Asteroid
‎04-24-2021 08:53 AM

here is my solution  ! 

challenge_237_solution.yxwz
Reply
0 Likes
Live Weekly Challenge