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 #36: Data Cleansing Extract Authors

joemkcarr
8 - Asteroid
 
Hannah_Lissaman
11 - Bolide

My solution :)

sagarb
8 - Asteroid

Using multi-row formulas

cgoodman3
14 - Magnetar
14 - Magnetar

Definitely done this with too many tools...

Spoiler
Challenge 36.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
anaibeth
8 - Asteroid

Here's my submission 🙂 

challenge 36.PNG

myastarling
10 - Fireball

This challenge was *wonderful*. Here's why: there's ways of doing this, and there's efficient ways of doing this.

 

My original solution was 8 tools, but it took some 30 seconds to run. Why? Because I used the concatenate function of the Summarize tool. That gummed up all of the works. 

I took a peek at other people's solutions and then when whole hog on the multi row tool and it takes a mere second or two to run. 

I included both of them in the attached workflow.

Greg_Murray
12 - Quasar

Solution attached

smoskowitz
12 - Quasar

This one was fun, but adding in the old style icons messed me up. 😄

willdupre
7 - Meteor

Found this quite tough, and definitely could have been more efficient - but got there in the end and some good lessons learned.

sahinakos
8 - Asteroid