Grouping value in same column

[Himal]

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

[bharti_dalal · Accepted solution]

Hi @Himal,

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

I have also attached the workflow for your reff. 

Happy learning.

[LordNeilLord]

@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