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
Astéroïde

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

carmenrapariz
Astéroïde
Révélation
Challenge 36.PNG
MatthewBr
Alteryx Alumni (Retired)

Always like testing my regex abilities

MichaelPilotFreight
Astéroïde

Check out my solution!

Kevin_VANCAPPEL
Boule de feu

Hello,

 

  here is my proposal.

 

  Regards,

  Kévin V.

ARussell34
Astéroïde

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
Révélation
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
Astéroïde
Révélation
Harrylosborne_0-1631886153961.png