Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

mceleavey
17 - Castor
17 - Castor

Right, no problems here, just some nice parsing.

 

Spoiler
I used the sample tool to skip the first line, and then used "Text to Columns" to split the field into two columns using the "-".
I then used the "Data Cleansing" tool to strip out the leading whitespaces.
I used the "Multi-row formula" tool to assign the PMID value to all rows within a record, then filtered to only show the FAU rows. I then used the "Multi-row Formula" tool to assign the author number then cross-tabbed into the right format.

Workflow.PNGResults.PNG


Bulien

hanykowska
11 - Bolide
 
bpatel
Alteryx
Alteryx
Spoiler
SPOILERchallenge 36.png
Verakso
11 - Bolide

Oh Boy!

 

This was actually a bit tougher than I thought, but I finally made it

 

Spoiler
It ain't pretty, but it works.

Seems like my FAU filter also included an address and that did mess up the result.

So after a lot of filtering and so forth, it came to look like this
The WorkflowThe Workflow

 

Still on my way to the Lhotse Face

/Verakso

Vidya26
8 - Asteroid

My Solution

RobertoEstrada
8 - Asteroid

My solution posted :)

dillon_bok
8 - Asteroid
Spoiler
Weekly Challenge - 36.PNG
RWvanLeeuwen
11 - Bolide

This brings back memories of writing science papers and learning anything possible from pubmed papers :-D

 

 

Spoiler
36.png

 

nickjastrzebski
8 - Asteroid

Not too bad, took a few attempts to get the cross tab to work as intended.

 

Spoiler
image.png
garthn555
8 - Asteroid
Spoiler
gn_challenge_36.png

My solution