ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

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