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 #271: Dynamic Double Dip

dheissner
Alteryx
Alteryx

You should add multiple input files with different data sets & structures to this example to better show the value in doing it these ways.

 

Spoiler
dheissner_0-1630414294971.png

 

Aaron
7 - Meteor

Complete

MatthewBr
Alteryx Alumni (Retired)

Twists and Turns of Cross Tab & Transpose

Original_Yodies
8 - Asteroid
Spoiler
Original_Yodies_0-1631625204215.png

 

GSD
7 - Meteor

My Solution :
Fun with regex functions , multi-row forumula's. Inspiration from official solution.

 

Spoiler
Challenge 271.jpg
allwynthomas24
11 - Bolide
Spoiler
allwynthomas24_1-1632926085644.png
Sebastiaandb
12 - Quasar
Spoiler
Sebastiaandb_0-1633071104127.png


Here's are my solutions! 

 

Maddie_Haines
6 - Meteoroid

One very clumsy, long solution and one much shorter one. 

Manav_Sehra
8 - Asteroid
Spoiler
Solution - Challenge #271.PNG

 Couldn't think of a second creative solution, so I settled with the simplest one. Hopefully it's admissible!

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

Spoiler
Weekly_Challenge_271.JPG