We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Renaming based on Categories

New2Coding
5 - Atom

Hi all! 
I'm a beginner to Alteryx and trying to familiarize with the logics behind achieving the desired output.
I have a data set (mentioned below) which has categories 1, 2 and 3 that has a list of people under the respective categories. 

 

image.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I want the respective Category to be updated beside each person's name like below:

image.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

I tried using the Multirow formula but couldn't get it to work! Can anyone guide me with this please? Haven't coded before and I spent a lot of time trying to figure this out! Appreciate the help!

 

 

2 REPLIES 2
kelsey_kincaid
12 - Quasar
12 - Quasar

Hi @New2Coding - does the below get you what you need?

 

kayers_0-1586362297447.png

 

 

 

New2Coding
5 - Atom

@kayers- It worked like a charm!! Thank you so much! Made my life easy.

Labels
Top Solution Authors