Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

Really nice exercise:

 

Emil_Kos_0-1627848144028.png

 

johnyli168
Alteryx
Alteryx

Solution attached. 

dfurlow
8 - Asteroid

good practice with organising a variable number of data points per key field ID!

carmenrapariz
8 - Asteroid
Spoiler
Challenge 36.PNG
MatthewBr
Alteryx Alumni (Retired)

Always like testing my regex abilities

MichaelPilotFreight
8 - Asteroid

Check out my solution!

Kevin_VANCAPPEL
10 - Fireball

Hello,

 

  here is my proposal.

 

  Regards,

  Kévin V.

ARussell34
8 - Asteroid

This one was a little tricky, but nonetheless I was able to find the solution. Who knew there could be that many authors for one article?

DanTh
Alteryx Alumni (Retired)
Spoiler
I felt this one was quite satisfying to do, using multiple Multi-Row blocks to build out Article and Author IDs.
DanTh_0-1629899077470.png

 

5/5
Harrylosborne
8 - Asteroid
Spoiler
Harrylosborne_0-1631886153961.png