In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. 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

Mattpannuzzo
7 - Meteor
‎03-14-2018 03:45 AM

My solution.

Uses the formula tool with IF statements to create the three columns after they've been transposed. 

 

Spoiler
challenge49solutionMPannuzzo.png
challenge_49_solution_MPannuzzo.yxmd
Reply
0 Likes
dsmdavid
11 - Bolide
‎03-18-2018 10:42 AM

One of the first times I have used the make columns tool...

 

Spoiler
49(1).png
solved#49.yxmd
Reply
0 Likes
Syfer889
7 - Meteor
‎03-23-2018 07:15 AM

Needed help on this one. Thank you for the many different solutions. Went the popular route.

challenge_49_Syfer.yxmd
Reply
0 Likes
luciebrett
8 - Asteroid
‎04-12-2018 05:20 AM

Pretty similar just ended with data cleansing rather than using formula to trim before.

challenge_49_LB.yxmd
Reply
0 Likes
ponraj
13 - Pulsar
‎04-14-2018 01:01 AM

uploading the solution. 

challenge_49_solution.yxmd
Reply
0 Likes
mascarenhas_lucas
8 - Asteroid
‎04-16-2018 08:35 AM
Spoiler
challenge_49.PNG
challenge_49_lucasmascarenhas_solution.yxmd
Reply
0 Likes
daniel_ferreira
8 - Asteroid
‎04-18-2018 07:34 PM

Follow my solution file attached...

challenge_49_solved.yxmd
Reply
0 Likes
StevenBetts
8 - Asteroid
‎04-27-2018 07:11 AM

Here's how I solved this this :)

challenge_58_start_file_SMB.yxmd
challenge_49_start_file_SMB.yxmd
Reply
0 Likes
AndyBate
8 - Asteroid
‎05-03-2018 03:26 AM

Complete

challenge_49.yxmd
Reply
0 Likes
KOBoyle
11 - Bolide
‎05-14-2018 05:28 PM

Solution attached.

challenge_49_solution_KO.yxmd
Reply
0 Likes