# Airtable - filtert data from column

**URL:** <https://community.thunkable.com/t/airtable-filtert-data-from-column/73280>\
**Category:** Questions about Thunkable X\
**Tags:** airtable\
**Created:** [March 23, 2019, 6:06pm UTC](https://community.thunkable.com/t/airtable-filtert-data-from-column/73280 "2019-03-23T18:06:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Maciek\_Samoraj](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maciek_samoraj/32/30952_2.png) [@Maciek\_Samoraj](https://community.thunkable.com/u/Maciek_Samoraj)\
**Post date:** [March 23, 2019, 6:06pm UTC](https://community.thunkable.com/t/airtable-filtert-data-from-column/73280/1 "2019-03-23T18:06:58Z")

</div>

Hi,

I’m working on a certain project and I have a small problem with displaying data. I added a view list to my application, which takes data from the airtable project [https://nimb.ws/VftEhC](https://nimb.ws/VftEhC), Everything is ok, the data is displayed according to the value of the column [https://nimb.ws/vFy2be](https://nimb.ws/vFy2be).

The problem is that I would not like to duplicate data and have only unique values (should be only four unique values). The question is how to do it and is it possible?

Best regards,

---

<div class="post-metadata">

**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\
**Post date:** [April 1, 2019, 11:03am UTC](https://community.thunkable.com/t/airtable-filtert-data-from-column/73280/2 "2019-04-01T11:03:30Z")

</div>

Hi @Maciek_Samoraj, welcome to the Thunkable Community!

Apologies for the delayed response, here’s a method you can use to go through a list and remove duplicates.

### Create a “temp” list

In this example I’ve called it `listWithoutDuplicates` but you can use what ever name you like.  
 ![48](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/3/f3a408c98f836c39ac96bf650b6e37ac9ac7159e.png)

### remove duplicates

Here we create a function to loop though all of the items in the original list. If the items is new we add it to the `listWithoutDuplicates` but if its a duplicate we skip it…

 ![57](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/88984c9f34d83a2691921cedf234c2a5cad7ced5.png)

### Choose an event

Finally, you just need an event to call the `removeDuplicates` function. I’ve gone for a button click, but you might opt for that data being returned from Airtable, for example.

![01](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/1/911789bcbe4ec93d8b453aff4454662c318a4373.png)

Hope that helps!

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [November 8, 2024, 12:15pm UTC](https://community.thunkable.com/t/airtable-filtert-data-from-column/73280/3 "2024-11-08T12:15:53Z")

</div>