# Search for duplicates in Make/Integromat **URL:** \ **Category:** Ask for Help\ **Tags:** api\ **Created:** [August 2, 2023, 12:10pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619 "2023-08-02T12:10:25Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![Dirk](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dirk](https://community.glideapps.com/u/Dirk)\ **Post date:** [August 2, 2023, 12:10pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/1 "2023-08-02T12:10:25Z")
Hi all, We use Integromat/Make to add new data to Glide. The data rows has all unique values set by the external source. We would like to check first the Glide table for duplicates before adding the new data rows. Since Glide have not their own modules (will this be availalbe some day?) we use HTTP modules. If we get all table rows and search for duplicates the filter will have the output 0 (when there aren’t duplicates). When this happens the scenario will stop since the filter hasn’t found any rows (since no duplicates). Any idea how we can make this work so we can continue the scenario when there are no duplicated rows? Thank you in advance. All the best! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 2, 2023, 12:15pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/2 "2023-08-02T12:15:54Z")
Maybe I’m misunderstanding, but isn’t this just a matter of setting up a filter in your Make scenario such that it only continues when the result set is empty? 🤷‍♂️ ---
**Author:** ![Dirk](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dirk](https://community.glideapps.com/u/Dirk)\ **Post date:** [August 2, 2023, 12:44pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/3 "2023-08-02T12:44:16Z")
Hi Darren, Thanks for your quick reply. When I use the Make filter with condition ‘not equal to’ all the other rows (that are not matching) will continue. This is not what we want 🙂 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/8/08f7faa3696b91deff0660318add4a136478aef0.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/51d5e910c83a9a5887491341af501fb3480d591c.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [August 2, 2023, 1:18pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/4 "2023-08-02T13:18:46Z")
Okay, I see the issue. I have a feeling that using an iterator may not be the best option here. You really need something that’s only going to return a result once it’s finished examining the complete set. @ThinhDinh - I’m thinking your `map` technique is probably the ticket here? ---
**Author:** ![Dirk](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dirk](https://community.glideapps.com/u/Dirk)\ **Post date:** [August 2, 2023, 2:31pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/5 "2023-08-02T14:31:02Z")
Thanks Darren, We have tried find a solution by using a combination of an aggregator and an iterator but still haven’t found the solution. I hope the mapping option will help us here. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [August 2, 2023, 4:17pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/6 "2023-08-02T16:17:30Z")
maybe something like this ![Screen Shot 2023-08-02 at 12.13.57 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/7/d7305064204859d4b33929885e73d3ec84e36910.jpeg) ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 2, 2023, 11:28pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/7 "2023-08-02T23:28:42Z")
> [@Darren\_Murphy](#): > > I’m thinking your `map` technique is probably the ticket here? Yeah, I think a map will work here. Basically it would mean mapping the “check value” against a column in the database. If it returns anything (which means there’s a duplicate) then don’t proceed. As Eric showed above, it can be structured as a branch condition. Maybe we don’t need the get function, since the map alone might be enough to check if a duplicate exists or not (it returns an array). ---
**Author:** ![Dirk](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dirk](https://community.glideapps.com/u/Dirk)\ **Post date:** [August 3, 2023, 1:29pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/8 "2023-08-03T13:29:07Z")
Hi Eric & Thinh, Thank you for your suggestion. We tried to duplicate your suggestions but we had some troubles with it. Would it be possible to clarify the filter part? Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 4, 2023, 12:45am UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/9 "2023-08-04T00:45:51Z")
Can you show us how are you configuring it in some screenshots? > **[Mapping Help Docs | Integromat Help Center](https://www.integromat.com/en/help/mapping)** > > What Is Mapping? Modules in a scenario are linked to each other by item mapping. When you map an item , you use the data retrieved using a source mod They cover it in the section “Mapping an Array’s Element with a Given Key” here. ---
**Author:** ![Dirk](https://avatars.discourse-cdn.com/v4/letter/d/87869e/32.png) [@Dirk](https://community.glideapps.com/u/Dirk)\ **Post date:** [August 4, 2023, 4:03pm UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/10 "2023-08-04T16:03:20Z")
We tried our best here but no results so far. It’s feeling like a common search, comparing two different databases but we can’t find any help on other websites as well. Any thoughts? Otherwise we need to look for an Integromat/Make expert. Thanks! ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [August 5, 2023, 12:33am UTC](https://community.glideapps.com/t/search-for-duplicates-in-make-integromat/64619/11 "2023-08-05T00:33:30Z")
Again, can you show us how you’re configuring it? We must know what you’re trying to see where it’s going wrong and how we can help.