Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

bhanusareen
7 - Meteor

I am a relatively new Alteryx user and I am not sure if my solution is the correct one or not but i took the easier route. and it gets me the correct output.
I removed the top row in the data file to get the correct column names
F38 corresponds to age column

used text to column to get the response and ages in two different columns
renamed the response column as per the value corresponding to 38 in column value in the questions file.

 

bhanusareen_0-1649413710909.png

 

TonyAndriani
9 - Comet

Reposting under my new user ID.

binuacs
20 - Arcturus
Spoiler
binuacs_0-1651523596822.png

 

m-wolters
8 - Asteroid

My solution

mmontgomery
11 - Bolide

Challenge #50

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_0-1655194695063.png

 

I was expecting this to be much harder but matching the output ended up being pretty easy!

RobbieA
8 - Asteroid

Challenge 50 Solution:

Spoiler
RobbieA_0-1655199947853.png

 

ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
harrame
8 - Asteroid
8 - Asteroid
Spoiler
harrame_0-1657209089854.png

I love getting to use the dynamic rename tool!

 

acarter881
12 - Quasar

Here's my solution.

Spoiler
my_weekly_challenge_50_solution.png