# Need Help in removing duplicates after entries are coming from Make **URL:** \ **Category:** Ask for Help\ **Created:** [December 11, 2024, 2:05pm UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521 "2024-12-11T14:05:48Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [December 11, 2024, 2:05pm UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/1 "2024-12-11T14:05:48Z")
Hi guys, I am using [Make.com](http://Make.com) to fetch some data on a daily basis. I fetch data which basically inputs Text in a column and Other data. Since its done on daily basis sometimes same text messages are copied into the database. I want it to remove duplicates when added. Is there a way to handle this in glide automatically? Without having any user intervention as soon as make write data to glide table?? Thank you in advance for your help. Regards, Dilip ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [December 12, 2024, 1:28am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/2 "2024-12-12T01:28:05Z")
Is there an identifier for each item? If so, I’d add a query rows module in your Make Scenario to see if the duplicate has already been added. If so, filter that one out before adding the new ones. ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [December 12, 2024, 8:13am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/3 "2024-12-12T08:13:54Z")
Hi @Robert_Petitto , Thank you for your reply. Unfortunately currently the API response is not giving me any identifier. I used combination of this solution from @Jeff_Hager > [@Is there a way to filter duplicates from an inline list?](https://community.glideapps.com/t/is-there-a-way-to-filter-duplicates-from-an-inline-list/21270/14): > > This is what I would do if you wanted to keep everything within glide. First I would recommend having a RowID which will give every row a unique value. This will become important in a little bit. Then I would identify a unique value for each contact, whether it’s a name, phone number, email address, or something else that you know will be in each duplicate row, but is still unique only for that specific person. Let’s assume Name for now. Create a self relation that links the contact’s Name … and by configuring workflow **PS** **Since I had Beta access to scheduled workflow I could test it** I think the bigger issue in this would be when the table size increases and duplicates increate, each delete costs me an update, which becomes an issue. Regards, Dilip ---
**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:** [December 13, 2024, 12:42am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/4 "2024-12-13T00:42:07Z")
> [@Dilip\_Adiga](#): > > Thank you for your reply. Unfortunately currently the API response is not giving me any identifier. Then how do you know it’s a duplicate when you add it to Glide later? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [December 13, 2024, 12:55am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/5 "2024-12-13T00:55:52Z")
Hi @ThinhDinh Thank you for your reply. Unfortunately I have to now rely on crude method of comparing texts I.e. the text column is compared with self to check whether it is duplicated Since there is no identifier coming in the api I guess this is the only option I have? Regards, Dilip ---
**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:** [December 13, 2024, 1:52am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/6 "2024-12-13T01:52:46Z")
I mean what “text column” are you referring to here? Is it part of the API response? If not, how do you know a row is duplicated or not later on? ---
**Author:** ![Dilip\_Adiga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilip_adiga/32/60330_2.png) [@Dilip\_Adiga](https://community.glideapps.com/u/Dilip_Adiga)\ **Post date:** [December 13, 2024, 2:31am UTC](https://community.glideapps.com/t/need-help-in-removing-duplicates-after-entries-are-coming-from-make/78521/7 "2024-12-13T02:31:12Z")
Hi @ThinhDinh, Yeah the text is part of api response. Everytime the api is queried I get text in response which I write to my text column of the table where I store this response. The api just sends me entire response everyday meaning it will send older data plus new data everyday when queried So hence in my table old response plus new response gets added meaning the “text” Now my problem is the text column which is storing the response it gets from api since it’s written everyday there will be duplicates right I need to remove them or let api not write the existing values in the table again from api PS I use make to call api and write response into glide table Regards, Dilip