Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #36: Data Cleansing Extract Authors

TimN
13 - Pulsar
Spoiler
TimN_0-1632355173379.png

 

Ukashi
8 - Asteroid

It was a bit tricky 🙂

but there is my solution:

 

Spoiler
Ukashi_0-1632400500838.png

 

Thank you for challenge!

alexnajm
19 - Altair
19 - Altair

One book has 264 authors?!

Spoiler
challenge_36_start_file_Alex Abi-Najm.PNG
pdave87
11 - Bolide

This exercise was solved using core tool set and it really evaluates the thinking process to transform data (went into lot of steps so containerized it). It was brilliant exercise.

 

Thanks to all SMEs. PFA my solution.

 

Regards,

Pratik

pdave87
11 - Bolide

Well, PMID copy and creating sequence has cut the steps into half in actual provided. Didn't struck and learning continues 🙂

OliverHosking
8 - Asteroid

Hello,

 

Here is my solution

leozhang2work
10 - Fireball
Spoiler
36.png

Not entirely sure about the final sorting, but join up to 5 authors agree with the answer.

Virgile_Haution
7 - Meteor

My solution to this challenge ! It gave me quite a headache and I had to use community resources to solve it. Ended up with a workflow similar to @JoshKushner 👍 

 

PatForData
8 - Asteroid
Spoiler
PatForData_0-1636563188017.png

 

allwynthomas24
11 - Bolide
Spoiler
allwynthomas24_0-1636805128412.png