# Filter data activity

**URL:** <https://forum.uipath.com/t/filter-data-activity/391970>\
**Category:** Activities\
**Tags:** data-manipulation, datatable, question, system, activities\
**Created:** [January 18, 2022, 9:53am UTC](https://forum.uipath.com/t/filter-data-activity/391970 "2022-01-18T09:53:17Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alok\_Dwivedi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/alok_dwivedi/32/180703_2.png) [@Alok\_Dwivedi](https://forum.uipath.com/u/Alok_Dwivedi)\
**Post date:** [January 18, 2022, 9:53am UTC](https://forum.uipath.com/t/filter-data-activity/391970/1 "2022-01-18T09:53:17Z")

</div>

i used filter data activity but its and want to filter specific data from data table but its not remove that please help me asap.

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 18, 2022, 9:55am UTC](https://forum.uipath.com/t/filter-data-activity/391970/2 "2022-01-18T09:55:19Z")

</div>

Can you share a Snap of your filter data table activity

---

<div class="post-metadata">

**Author:** ![Shikhar\_Tandon](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shikhar_tandon/32/176817_2.png) [@Shikhar\_Tandon](https://forum.uipath.com/u/Shikhar_Tandon)\
**Post date:** [January 18, 2022, 9:55am UTC](https://forum.uipath.com/t/filter-data-activity/391970/3 "2022-01-18T09:55:21Z")

</div>

HI @Alok_Dwivedi ,

If you are using a filter datatable activity then you need to check the remove option.

![image](https://global.discourse-cdn.com/uipath/original/4X/f/6/7/f67d5474c16543a6b6ece6792884f86bb1d3cb3f.png)

---

<div class="post-metadata">

**Author:** ![Alok\_Dwivedi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/alok_dwivedi/32/180703_2.png) [@Alok\_Dwivedi](https://forum.uipath.com/u/Alok_Dwivedi)\
**Post date:** [January 18, 2022, 9:59am UTC](https://forum.uipath.com/t/filter-data-activity/391970/4 "2022-01-18T09:59:43Z")

</div>

![image](https://global.discourse-cdn.com/uipath/original/4X/e/4/1/e41258d04330b3bbcdcbcc6022305d8bc23490f0.png)

---

<div class="post-metadata">

**Author:** ![Shikhar\_Tandon](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/shikhar_tandon/32/176817_2.png) [@Shikhar\_Tandon](https://forum.uipath.com/u/Shikhar_Tandon)\
**Post date:** [January 18, 2022, 10:02am UTC](https://forum.uipath.com/t/filter-data-activity/391970/5 "2022-01-18T10:02:12Z")

</div>

In Column, you need to pass the column Name and what does value Level contains?

---

<div class="post-metadata">

**Author:** ![Alok\_Dwivedi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/alok_dwivedi/32/180703_2.png) [@Alok\_Dwivedi](https://forum.uipath.com/u/Alok_Dwivedi)\
**Post date:** [January 18, 2022, 10:06am UTC](https://forum.uipath.com/t/filter-data-activity/391970/6 "2022-01-18T10:06:07Z")

</div>

There is no column name and value of level is 8926.

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 18, 2022, 10:10am UTC](https://forum.uipath.com/t/filter-data-activity/391970/7 "2022-01-18T10:10:30Z")

</div>

hi @Alok_Dwivedi

Can you make a try with linq

```auto
Out_Dt=(
              From row in DataTable
              where row(0)="8926"
               Select row
              ).CopyToDataTable

```

put the above query in assign activity

Where Out\_Dt is a datatable type variable

hope it solves your issue

Thanks,  
Robin

---

<div class="post-metadata">

**Author:** ![Alok\_Dwivedi](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/alok_dwivedi/32/180703_2.png) [@Alok\_Dwivedi](https://forum.uipath.com/u/Alok_Dwivedi)\
**Post date:** [January 18, 2022, 10:31am UTC](https://forum.uipath.com/t/filter-data-activity/391970/8 "2022-01-18T10:31:46Z")

</div>

Assign: The source contains no DataRows. It show error not working

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 18, 2022, 10:35am UTC](https://forum.uipath.com/t/filter-data-activity/391970/9 "2022-01-18T10:35:49Z")

</div>

can you share a snap ?? of the assign activity

---

<div class="post-metadata">

**Author:** ![Robinnavinraj\_S](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/robinnavinraj_s/32/177041_2.png) [@Robinnavinraj\_S](https://forum.uipath.com/u/Robinnavinraj_S)\
**Post date:** [January 18, 2022, 10:42am UTC](https://forum.uipath.com/t/filter-data-activity/391970/10 "2022-01-18T10:42:19Z")

</div>

sry i missed Tostring method

![image](https://global.discourse-cdn.com/uipath/original/4X/f/8/0/f8033c0ed881029bf99a6cffd28d2b5b163b0e15.png)  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/5/d/3/5d3ce7e04ee80cd5816612edb131042230322140.png)

Thanks  
Robin