ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

deepaprash
8 - Asteroid

Solved!

mike_w
8 - Asteroid

this one was harder than most of the other ones that I did so far, in prep for the Core Exam. But I really learned something especially reg the Cross Tab tool

jyothiganti
7 - Meteor

Hi, how to download this file (pubmed_result.txt), I"m unable to add this file to my workflow.

ishizuka
7 - Meteor

Here is my solution

dougperez
12 - Quasar

I broke my head in this and my solution was not so elegant haha

Normster
8 - Asteroid

I filtered the required fields to start rather than parsing.  It took me an extra step but it seems like it was less effort.

 

Spoiler
Normster
Spoiler
Normster_0-1593867617023.png

 

VVill_T
7 - Meteor

A slightly different attempt from others 

attilajozsefhegedus
7 - Meteor

int

AkshayB
7 - Meteor

Challenge_36_Solution

AkshayB
7 - Meteor

Challenge_36_solution