Calling all Alteryx customers: Refer your colleague to try Alteryx and receive a $50 gift card. Sign up now!
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 #303: International Bank of Awesome Data - Part II

AGilbert
11 - Bolide
‎04-04-2024 03:01 PM
Spoiler
Screenshot 2024-04-04 145927.png
Challenge 303_ag.yxzp
Reply
0 Likes
Bobbyt23
12 - Quasar
‎08-22-2024 05:17 AM

Just went for the lots of REPLACE function option in this one.

Weekly Challenge 303 22-08-24.yxzp
Reply
Yogesh1795
8 - Asteroid
‎09-17-2024 06:29 PM

Simple Challenge for me. I love power of Macros and I love Alteryx

Challenge 303_Solution.yxmd
Reply
0 Likes
lwolfie
11 - Bolide
‎09-27-2024 12:41 PM

Done!

Challenge 303_Solution_LW.yxzp
Reply
0 Likes
Carolyn
12 - Quasar
12 - Quasar
‎12-02-2024 04:43 PM

Solved!

 

After I built the macro with some ugly Multi-Field + If/Then Formulas, I looked at @AngelosPachis's solution which was so much cleaner for how to handle that portion of the macro. Thank you, Angelos :) 

 

Spoiler
2024-12-02_16-39-44.png 

2024-12-02_16-39-28.png

 

Challenge 303_Start File.yxzp
Reply
0 Likes
i-godz
8 - Asteroid
‎03-13-2025 04:24 AM

Data Preparation Macro

Spoiler
Screenshot 2025-03-13 132041.png

Main Workflow

Spoiler
Screenshot 2025-03-13 132120.png

 

Solution File.yxmd
Data Preperation Macro.yxmc
Reply
0 Likes