community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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

 

Quasar

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