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

RS452
7 - Meteor
‎10-07-2021 03:49 AM

Good one..

challenge_49_RS452.yxmd
Reply
0 Likes
Joe_Lipski
13 - Pulsar
13 - Pulsar
‎10-09-2021 09:48 AM

🙂

Joe Lipski
challenge_49_JL.yxmd
Reply
0 Likes
NISCHITHA-98
8 - Asteroid
‎10-12-2021 04:49 AM

Solution

challenge_49_solution.yxmd
Reply
0 Likes
WasimS
8 - Asteroid
‎10-13-2021 04:38 AM
Spoiler
Spoiler

Challenge 49.png

challenge_49_My_Solution_WS.yxmd
Reply
0 Likes
jjrbondoc
8 - Asteroid
‎10-13-2021 07:19 AM
Spoiler
jjrbondoc_0-1634134769063.png

 

challenge_49_jjb.yxmd
Reply
0 Likes
MariusNikiforovas
8 - Asteroid
‎10-13-2021 02:35 PM
Spoiler
MariusNikiforovas_0-1634160900353.png

 

challenge_49_start_file.yxmd
Reply
0 Likes
rrozanski002
8 - Asteroid
‎10-20-2021 05:30 AM

Done

challenge_49_start_file.yxmd
Reply
0 Likes
KodyKlein
6 - Meteoroid
‎10-20-2021 02:19 PM

My tutor showed me how to do this a week ago. I waited a week and attempted to recreate the workflow without looking back at any notes. It took me a minute, but I finally got it! 

 

KodyKlein_0-1634764699319.png

 

challenge_49_start_file (1) solution on 10-20-21.yxmd
Reply
0 Likes
davidhe
Alteryx Alumni (Retired)
‎10-21-2021 10:02 AM

Could be a macro? 

Spoiler
davidhe_0-1634835721531.png

 

DataPrep_ReformattingData.yxmd
Reply
0 Likes
KodyKlein
6 - Meteoroid
‎10-21-2021 11:17 AM

Thanks so much for the feedback! I'm as green as it gets, so I really appreciate it. I downloaded your file and looked through your workflow. I like it a lot! It seems very elegant to separate the dataset into separate datasets for each product and then use a union tool to join them. I feel like the workflow I was taught is a bit visually simpler, but I think yours is more interesting, and really I like that you didn't have to use the formula tool to create new columns. 

Reply
Live Weekly Challenge