We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-10-20 105838.png
99tyler99
7 - Meteor

Alteryx Challenge 36 Extract Authors.png

afnfyz
8 - Asteroid

I am getting more and more comfortable with the crosstab and transpose tools!

Spoiler
Screenshot 2023-10-24 112551.png
Carolyn
8 - Asteroid

Solved - this was a good one 

 

Spoiler
2023-11-10_09-14-48.png
Tofel
8 - Asteroid
Spoiler
Challenge 36.JPG
AndrewDMerrill
13 - Pulsar

Simple but useful problem

Spoiler
Workflow.png
sknman92
8 - Asteroid

solution attached!

Rob-Silk
8 - Asteroid

My solution below:

Spoiler
challenge_36_RS_screencap.PNG
fluteman
8 - Asteroid

This one required some formatting. You need to determine each block of information as its own Unique ID; You also need to figure out which rows in a given block pertain to a given book variable indicated by AB-; TI- etc. Watch out for paragraphs within the TI and AB what contain words with a -, these will throw off the formatting.

 

Then you pair your unique ID with the actual PMID;

Filter on FAU.

 

I used summarize by concatenate by ";" and then text to columns (30) splitting this cell. 

 

As a check I measured how many authors were against each book. there's a book with 264 authors; so I capped my columns at 30 and thought that was the gist of this exercise!

jennifer_owens
8 - Asteroid

attached!