community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Grouping value in same column

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

Highlighted
Alteryx Certified Partner

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.

Alteryx Certified Partner

@Bharti

 

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