Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Here's my solution. Spoiler alert!

LisaD
8 - Asteroid

Not as pretty as others but it works.

 

RWvanLeeuwen
11 - Bolide

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

Spoiler
49.png
garthn555
8 - Asteroid
Spoiler
Spoiler
gn_challenge_49.png

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

ccruzagosto
7 - Meteor

My solution attached.

ELPC
8 - Asteroid

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

 

 

piotrzawistowski
8 - Asteroid
 
joshuaburkhow
ACE Emeritus
ACE Emeritus
Spoiler
A good example for Transform Join use case
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
JWS
Alteryx Alumni (Retired)

Great Challenge

RichardLengua
6 - Meteoroid

Still Gotta Practice with Cross Tabs and Transpositions.

Spoiler
Challenge_49_RL_Solution.PNG