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

KevinH1992
Alteryx Alumni (Retired)

Different from the others but it gets the job done.  

mcultrera
8 - Asteroid

This was harder than I expected.  Any time I have to cross tab and transpose there is a lot of trial and error to get it right.

 

I first just removed the first 3 rows and manually configure the table.  After I got that to work I went to generating the lookup table from the data.

kelsey_kincaid
12 - Quasar
Spoiler
Challenge49-KA.PNG
Cosmin_S
8 - Asteroid

I attached my solution. Thank you.

CapriceW
8 - Asteroid

Here goes!

Ioana_Radoveneanu
8 - Asteroid
Spoiler
49.jpg
CliffordC
Alteryx Alumni (Retired)

Probably a bit of overkill with a multi-field tool to trim the whitespace, but in the idea of keeping the workflow dynamic I thought it was appropriate.

willdupre
7 - Meteor

Took two alternate approaches - this is the (much) cleaner version.

rcor
8 - Asteroid
Spoiler
challenge_49_RC_solution.PNG
Marcel_Gavrila
8 - Asteroid

Here is my solution!

Spoiler
Capture.JPG