Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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 #64: Catch Me If You Can

RolandSchubert
16 - Nebula
16 - Nebula

My solution

KeithTroutt
8 - Asteroid

I got a little tripped up on the sort order but finally got it. 

Spoiler
Challenge 64 Spoiler.PNG
RichoBsJ
11 - Bolide

Hi! Here my solution :)

acrahen
8 - Asteroid

My first attempt using brute force

Spoiler
2019-02-04_10-24-15.jpg

Embarrassing my first attempt with a peek at some of the other answers

Spoiler
2019-02-04_10-24-57.jpg

 

cplewis90
13 - Pulsar
13 - Pulsar

This was a bit tricky, but after looking through some new tools I was able to get there.

Spoiler
Challenge 64.PNG
Sajeel_Kershi
8 - Asteroid

originally had transpose and join to the header formula followed by crosstab which puts in extra "_" into the fields names. Was going to follow up with a dynamic rename to remove extra "_" when I got the realisation that I can cut out the entire transpose > Join > Crosstab part and go straight to Dynamic rename. The Dynamic Rename tools are awesome!

Jonathan-Sherman
15 - Aurora
15 - Aurora

Pretty quick! Used a RecordID key to ensure the columns outputted remained in the same order as the initial input.

Spoiler
challenge 64 JMS solution.PNG
JonathanAllenby
8 - Asteroid

Here's my solution to challenge 64.

johnemery
11 - Bolide

Interesting challenge. I always try to make my workflows as simple and efficient as possible, so I'm pretty happy with this solution.

 

Spoiler
Capture.PNG
hanykowska
11 - Bolide

this seemed quite easy actually, don't know if I've cheated or not...