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

gautamsawant93
7 - Meteor
‎06-19-2019 02:06 PM

Here's my solution. Spoiler alert!

Gautam_49_solution.yxmd
Reply
0 Likes
LisaD
8 - Asteroid
‎06-19-2019 07:34 PM

Not as pretty as others but it works.

 

challenge_49_LRD.yxmd
Reply
0 Likes
RWvanLeeuwen
11 - Bolide
‎06-20-2019 04:56 AM

Time to call it a day (about 7-8 challenges a day does not keep the doctor away)

Spoiler
49.png
challenge_49_start_file - RWvL.yxmd
Reply
0 Likes
garthn555
8 - Asteroid
‎06-20-2019 06:41 AM
Spoiler
Spoiler
gn_challenge_49.png

The problem statement didn't specify how to produce the text columns

gn_challenge_49.yxmd
Reply
0 Likes
ccruzagosto
7 - Meteor
‎06-20-2019 09:03 AM

My solution attached.

challenge_49_CCA.yxmd
Reply
0 Likes
ELPC
8 - Asteroid
‎06-20-2019 11:12 AM

Here's my horrible solution.  I took way too many steps but got there.  Trying to learn from all the other posted workflows now.  

 

 

challenge_49_solution.yxmd
Reply
0 Likes
piotrzawistowski
8 - Asteroid
‎06-21-2019 02:26 PM
 
challenge_49_start_file_pzw.yxmd
Reply
0 Likes
joshuaburkhow
ACE Emeritus
ACE Emeritus
‎06-24-2019 10:20 AM
Spoiler
A good example for Transform Join use case
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
challenge_49_solution_JB.yxmd
Reply
0 Likes
JWS
Alteryx Alumni (Retired)
‎06-25-2019 09:49 AM

Great Challenge

challenge_49_solution_JS.yxmd
Reply
0 Likes
RichardLengua
6 - Meteoroid
‎06-25-2019 01:12 PM

Still Gotta Practice with Cross Tabs and Transpositions.

Spoiler
Challenge_49_RL_Solution.PNG


Reply
0 Likes
Live Weekly Challenge