We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #337: Create a New List from an Existing List

Joe_Tipper
6 - Meteoroid

First attempt at a weekly challenge...

DerikSadowski
7 - Meteor

Please see attached

Pete_Rodgers
Alteryx
Alteryx
Spoiler
Pete_Rodgers_0-1664206648332.png

 

Pete Rodgers
Solutions Engineer | UK&I Public Sector | Alteryx
dianawine
7 - Meteor

Solution

EFLOw
6 - Meteoroid
Spoiler
EFLOw_0-1664283823186.png

 

annbriceAB
7 - Meteor

Hi Everyone, here is my solution.  The first time I did it I used Formula to trim the Categories field but then I saw you can use Data Cleaning to trim white space while changing Nulls to empty strings. Thanks for the great challenges!  I am learning so much!

Carolyn
8 - Asteroid

Solution attached

anumol_92k
6 - Meteoroid

PFA Solution

RFajardo
6 - Meteoroid
Spoiler
RFajardo_0-1664372359265.png

 

neilreinke
6 - Meteoroid

My Solution

Spoiler
neilreinke_0-1664376670702.png