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