ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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 #366: Three Columns Are a Crowd

mg46
アステロイド

Nice easy one to close out the week. :)

 

スポイラ
mguarniere_0-1681501705264.png

 

Coakles
メテオール
スポイラ
スポイラ
Coakles_0-1681509927897.png

Good way to get more comfortable with transpose. 

 

PrachiD
アステロイド

summarize, parse, record ID

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

 

スポイラ
Weekly_Challenge_366.JPG
jcalteryx
Alteryx
Alteryx
スポイラ
My solution.

jcalteryx_0-1681609028541.png

 




DataNath
17 - Castor
17 - Castor

My solution to #366.

 

スポイラ
DataNath_0-1681642681003.png
sparekh1
メテオール

My Solution

 

スポイラ
sparekh1_3-1681723747333.png

 

ferg_smith
アステロイド
スポイラ
ferg_smith_0-1681725878199.png

 

dougbaron
アステロイド

nice and easy

スポイラ
dougbaron_0-1681736343535.png

 

dougbaron
アステロイド

@sparekh1 

I see that you used a join to compare actual vs expected output. I recommend getting the CREW macro set from the gallery. The Expect Equal macro is good for validating workflow output to the expected output.

 

https://community.alteryx.com/t5/Community-Gallery/CReW-Delta-Macro-Beta-version/ta-p/924519

 

dougbaron_0-1681736527636.png