This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Which tools can I use to delete duplicate rows in my data? For example:
38910 < I only want to keep this row of data and delete all other rows that match up to another descriptive number.
the Unique tool only gets rid of duplicates and keeps one of the matches. I want to delete all rows that can be matched up by descriptive number.
@wwilson Do you have the CReW macros? There is a tool that does this called Only Unique.
I do not have CReW macros. Do you know where I can download them from?
You can easily use a Join tool after the unique tool to do this.
The L output will be the set you want
This solutions rocks the best, quick easy and does the job!!