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 #50: Preparing Survey Data

Colintermeer
アステロイド

Answer

benjimoser
コメット

My Solution

スポイラ
benjimoser_0-1676903434989.png

 

JoeChan619
アステロイド

Solved.

スポイラ
challenge 50.png
ed_hayter
パルサー
スポイラ
ed_hayter_0-1677171330200.png

 

WernerE
アステロイド

This is my solution to the challenge. 

スポイラ
50.jpg
Shahbaz_analyst
アステロイド
スポイラ
Shahbaz_analyst_0-1677686134823.png

 

Nolan
メテオール

Here is my solution! I double checked my output and it is the same as the output in the solution file - no joins or cross tabbing required.  The "Age" question in the "Questions" input (row 28) does not return age response values, and in the solution file, the "Search_Experience" column is just parsed twice and the "Age" column is never used anyways. I was able to build my own version of the solution involving joins and cross-tabbing to pull column headers, but I still think this question was a bit unclear. Perhaps folks in this thread have a better understanding of this question and could clarify.

 

スポイラ
Nolan_0-1677686495213.png

 

Stieve2
アトム
スポイラ
Stieve2_1-1677710566282.png
Dani_Lin
アステロイド

solved

CeliaC_Silje
アステロイド
スポイラ
CeliaC_Silje_0-1678328524721.png