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 #49: Reformatting Transactional Data

RNG
8 - Asteroid
‎06-29-2020 11:27 PM

.

challenge_49_sol_file (1).yxmd
Reply
0 Likes
PhilBalderson
8 - Asteroid
‎06-30-2020 03:16 AM

Back to back transform and cross tab still blows my mind! 

challenge_49_solved2.yxmd
Reply
0 Likes
CHerv
7 - Meteor
‎06-30-2020 04:01 AM

Good challenge ... took a while to play about with cross-tab & transpose.

 

Spoiler
CHerv_0-1593514786814.png

 

challenge_49_start_file - CH.yxmd
Reply
0 Likes
DemandEngineer
8 - Asteroid
‎06-30-2020 11:25 AM

Not sure my approach was the simplest... will compare to solution next.

challenge_49_submitted.yxmd
Reply
0 Likes
fimler
8 - Asteroid
‎06-30-2020 07:09 PM
Spoiler
fimler_0-1593569320479.png

 

Two slightly different (first step) solutions with the same result.

My Challenge 49 Solution.yxmd
Reply
0 Likes
Ross_Easton
8 - Asteroid
‎07-03-2020 04:37 AM

Solved, probably should have made a macro here

49.PNG

 

 

Spoiler
 
challenge_49_complete ross.yxmd
Reply
0 Likes
gerizam
8 - Asteroid
‎07-06-2020 09:06 AM
Spoiler
gerizam_1-1594051560342.png

 

challenge_49_solution_GI.yxmd
Reply
0 Likes
treepruner
9 - Comet
‎07-07-2020 08:32 PM

Pretty sure I am brute force here and not elegant in my solution...

challenge_49_start_file.yxmd
Reply
0 Likes
AkshayB
7 - Meteor
‎07-07-2020 08:40 PM

Challenge_49_Solution

challenge_49_Solution.yxmd
Reply
0 Likes
ehughes
9 - Comet
‎07-08-2020 01:05 AM

My solution

Spoiler
Img 49.PNG

 

challenge_49_start_file.yxmd
Reply
0 Likes
Live Weekly Challenge