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

JoeChan619
8 - Asteroid

A nice challenge to practice Multi-Row Formula!

#36 challenge.png

François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1673618082373.png

 

Angelica_Obi
8 - Asteroid

Spoiler

 

ShankerV
17 - Castor

Had the thrill of solving!!!!

 

Spoiler
ShankerV_0-1673788810796.png

 

alacoume
9 - Comet

My solution:

benjimoser
9 - Comet

My Solution

Spoiler
benjimoser_0-1674216868813.png  
Flo_P
9 - Comet
Spoiler
Took me a while to realize there are publications with no authors, which was causing the difference..
Flo_P_0-1674224291345.png

 

danblythe
8 - Asteroid
Spoiler
Think I over complicated my formulas but they work :)
kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_36_KU.png
keynguyen
8 - Asteroid
Spoiler
challenge 36 sol.jpg