Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Grouping value in same column

Himal
6 - Meteoroid

Hi,

 

I have two excel sheets with me, keys and Products (Sheets Name). Keys sheet contains ID field,
and Products contains ParentID, DataCategoryGroupName and DataCategoryName. Id and ParentID are both same.

I need to find out those ParentID which exist only in Products sheets and I need unique values of ParentID,
with DataCategoryName next to each other (in same column) seperated by "; "

Sample excel file attached.

output
ParentID                                                                         DataCategoryName
ka0800000000IwQAAU                                      DirectControl; Identity_Service_Mac_Edition

2 REPLIES 2
bharti_dalal
10 - Fireball

Hi @Himal,

 

Solution to your problem requires only 2 tools, 1st is join tool and 2nd is Summarize tool. Here is the screen shot

 

image.png

I have also attached the workflow for your reff. 

 

Happy learning.

LordNeilLord
15 - Aurora

@bharti_dalal

 

If @Himal only wants the ones that appear in the products sheet then you'll need to output from the right not the join

Labels
Top Solution Authors