When Datawatch released Monarch V8 they included a very helpful feature in the filter window that will allow you to find duplicate values in your table. Once you have opened your report and model, go to the table window. Create a new filter by going to Data, Filter or by clicking on the filter icon. Click on New. Before you go to the Advanced tab, you must first give your filter a name, then click on Advanced. It will default to "Don't care about duplicates". Click on "Select rows according to their uniqueness…" Put a check mark in Duplicated rows. You will have the choice of selecting either one row only or all duplicated rows. Under Specify keys, put a check mark in the box for the field(s) where you want to find the duplicate values. At the bottom you can select either no limit to show all the rows or just the First # rows to show just the first row or first specified number of rows. Click OK. Then click OK again to return to your table. You will now see a list of only the rows that contain a duplicate value for the specified columns designated in the filter. To show all your records again, go back to the filter box by going to Data, Filter or clicking on the filter icon. Click inside the radial button for No Filter. Click OK and the table will display all of the records from your report. Click here for more detailed instructions .