Grouping value in same column

Question

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

Grouping Products.xlsx

bharti_dalal · Accepted Answer

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.