Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #360: Goodbye, Michael! (Part 2)

CharlotteGuy
8 - Asteroid
Spoiler
CharlotteGuy_0-1677532005739.png

 

Luke_C
17 - Castor
Spoiler
Luke_C_0-1677534718745.png

 

SandroGerber
8 - Asteroid
Spoiler
SandroGerber_0-1677536050435.png

 

kboeckholt
7 - Meteor

Nice one this week:

 

Spoiler
kboeckholt_0-1677538513739.png

 

Yoshiro_Fujimori
15 - Aurora

My Solution.

Spoiler
Usually I would use Multi-Row Formula for this kind of challenge.
This time I tried to use Dynamic Replace Tool, which I am not familiar with :)
Yoshiro_Fujimori_0-1677541597753.png

 

TonyAndriani
9 - Comet

My solution.

Spoiler
Flagged the lines with the song and sorted. If the input data set was much bigger, I would have added a Record ID at the beginning and a Sort at the end to ensure the lines appeared in the right order, but with a 2MB data set that should be necessary.

TonyAndriani_0-1677552092953.png

 

tbennett013
8 - Asteroid

My solution to Challenge #360

CanalB
8 - Asteroid

Hi ! 

here is my solution.

 

 

gerda
8 - Asteroid
Spoiler
gerda_0-1677580674310.png

 

Here's my solution! 

olga_strubbe
10 - Fireball
Spoiler
olga_strubbe_2-1677591305358.png

 


A nice and fun challenge, than you!