Avoid email duplicate by Using 'GROUP BY' in Console Analytics
Content
Hi All,
I have one requirement to group by the records by email.I have tried the "Group Result" functionality. If I gave only email column its working fine.Once I added the Name & ID, it will again show the duplicate values. Because ID have unique value.
How to avoid the duplicate report
Ex: I have below 3 columns
1.ID
2.Contractor Name
3.Contractor Email ID
Based on columns, I need to groupby the email ID alone.
Any suggestions?
Thanks,
Seethalakshmi
Tagged:
1