Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

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