community Alteryx IO Mission Control
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 #49: Reformatting Transactional Data

lapin_dangelau_24
7 - Meteor
‎02-06-2023 06:37 AM

my solution

challenge_49_solution.yxmd
Reply
0 Likes
akorte1
8 - Asteroid
‎02-07-2023 12:42 PM

Done

Reply
0 Likes
richmondbound
8 - Asteroid
‎02-10-2023 07:04 AM

This transpose and cross tab work is something serious, how do you stay on top of it. Very mind bending.

challenge_49_start_file.yxmd
Reply
0 Likes
Daniel1127
8 - Asteroid
‎02-12-2023 03:40 PM

Solution as attached

challenge_49_start_file.yxmd
Reply
0 Likes
longyanChen
8 - Asteroid
‎02-13-2023 09:54 AM

HI

challenge 49.yxzp
Reply
0 Likes
Milly103
8 - Asteroid
‎02-14-2023 01:43 AM

I've got to the solution without using a join, but using IF formulas instead to rename the headings.

challenge_49_complete.yxmd
Reply
0 Likes
Colintermeer
8 - Asteroid
‎02-14-2023 03:01 AM

Answer

challenge_49.yxmd
Reply
0 Likes
RobbieA
8 - Asteroid
‎02-15-2023 02:22 AM

My solution to 49:

 

challenge_49_RA.yxmd
Reply
0 Likes
Shahbaz_analyst
8 - Asteroid
‎02-15-2023 07:47 AM
Spoiler
Shahbaz_analyst_0-1676476008223.png

 

challenge_49_start_file.yxmd
Reply
0 Likes
Crispy131
8 - Asteroid
‎02-15-2023 03:53 PM

Solved

challenge_49_start_file.yxmd
Reply
0 Likes