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