Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 Alumni (Retired)

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