community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
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

SophiaF
Alteryx
Alteryx
‎08-12-2019 06:34 AM

Formula!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
challenge_36_SOPH_DONE.yxmd
Reply
0 Likes
David-Carnes
12 - Quasar
‎08-16-2019 01:35 PM
Spoiler
036.png
David-Carnes_036.yxmd
Reply
0 Likes
FRANCK_ROUQUETTE
8 - Asteroid
‎08-19-2019 01:31 PM

thank you for the exercise - attached my solution

challenge_36_FranckR.yxzp
Reply
0 Likes
chetty
8 - Asteroid
‎08-19-2019 06:49 PM

My solution attached

challenge_36_SC.yxmd
Reply
0 Likes
sachinw
8 - Asteroid
‎08-20-2019 05:55 AM

My Solution:

challenge_36_solution.yxmd
Reply
0 Likes
jagdeep_singh85
8 - Asteroid
‎08-22-2019 08:19 PM

PFA My Solution

challenge_36_Solution(By_Jagdeep).yxzp
Reply
0 Likes
ddiesel
13 - Pulsar
13 - Pulsar
‎08-25-2019 01:02 AM

Quick, easy, and fun one.

 

My solution:

Spoiler
Capture.JPG
challenge_36_end_file_ddiesel.yxmd
Reply
0 Likes
PhilBalderson
8 - Asteroid
‎08-27-2019 07:06 AM

After filtering initial results, I used multi row formula to assign PMID as the Unique ID for each author, and completed using summarize and text to columns. 

challenge_36_solved.yxmd
Reply
0 Likes
mbogusz
9 - Comet
‎08-29-2019 06:18 AM
Spoiler
2019-08-29 09_16_42-Greenshot.png
challenge_36_solution_mbogusz.yxmd
Reply
0 Likes
alexm06
8 - Asteroid
‎08-29-2019 07:01 AM

A convoluted solution

challenge_36_complete_file.yxmd
Reply
0 Likes
curated machine learning resources