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
Alteryx
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