community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #36: Data Cleansing Extract Authors

Spoiler
Capture.PNG
Alteryx Certified Partner

I tried the summarise tool at the beginning but there were not enough space to concatenate all authors, so took another approach with a cross tab. 

Spoiler
Screen Shot 2017-10-29 at 17.25.06.png

 

Bolide

I am quite please with how elegant this solution is. EXCELENT challenge.

Spoiler
Capture.PNG
Fireball

Regex will never fail me...I hope

Bolide
Bolide

More fun with parsing and assembling tables!

Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_36 - Snip.PNG
Asteroid

Solution attached.

Quasar

Solution attached.

Alteryx Certified Partner

my good old multirow friend.

 

Spoiler
challenge36.png
Alteryx Certified Partner

Solution attached. Nice example of why I never rely on commas as delimiters if I can help it.

 

Spoiler
Screen Shot 2017-12-26 at 21.37.53.png