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
Asteroid

Solved!

mike_w
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
Meteor

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

ishizuka
Meteor

Here is my solution

dougperez
Quasar

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

Normster
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
Meteor

A slightly different attempt from others 

int

AkshayB
Meteor

Challenge_36_Solution

AkshayB
Meteor

Challenge_36_solution