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
Solved! Go to 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.
If @Himal only wants the ones that appear in the products sheet then you'll need to output from the right not the join