# Filter rows in a table

**URL:** <https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [July 31, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160 "2023-07-31T17:18:44Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ines\_jukic](https://avatars.discourse-cdn.com/v4/letter/i/5f8ce5/32.png) [@ines\_jukic](https://forum.inductiveautomation.com/u/ines_jukic)\
**Post date:** [July 31, 2023, 5:18pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/1 "2023-07-31T17:18:45Z")

</div>

Hi everyone,

I want to filter rows in a column of a table that is in a tag, the value of the filter is in another tag. I´ve tried with this code but it's not working

```auto
valor_filtro = system.tag.read("[default]Mecanizado/InputPallet").value
tagtabla = "[default]Mecanizado/Blocks-Pallets"
datatabla = system.dataset.toPyDataSet(system.tag.read(tagtabla).value) 

tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]

system.tag.write("[default]Mecanizado/tablaimpresion",tabla_filtrada.value)

```

I would appreciate any help or information you could give me. Thank you!

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [July 31, 2023, 5:28pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/2 "2023-07-31T17:28:48Z")

</div>

> [@ines\_jukic](#):
>
> `tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]`

That's not valid python.

> [@Problem to filter dataset](https://forum.inductiveautomation.com/t/problem-to-filter-dataset/77140/3):
>
> def filter\_dataset(ds, condition): return system.dataset.toDataSet(list(ds.columnNames), filter(condition, system.dataset.toPyDataSet(ds))) filter\_dataset(ds, lambda row: row['zone'] == 'A')

---

<div class="post-metadata">

**Author:** ![ines\_jukic](https://avatars.discourse-cdn.com/v4/letter/i/5f8ce5/32.png) [@ines\_jukic](https://forum.inductiveautomation.com/u/ines_jukic)\
**Post date:** [July 31, 2023, 6:11pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/3 "2023-07-31T18:11:52Z")

</div>

sorry i don't understand ☹

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [July 31, 2023, 6:18pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/4 "2023-07-31T18:18:59Z")

</div>

Tell me what you don't understand and I'll try to explain.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [July 31, 2023, 6:38pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/5 "2023-07-31T18:38:58Z")

</div>

> [@ines\_jukic](#):
>
> `tabla_filtrada = datatabla[datatabla['Pallet'] == valor_filtro]`

What do you want this line to do?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 31, 2023, 7:14pm UTC](https://forum.inductiveautomation.com/t/filter-rows-in-a-table/77160/6 "2023-07-31T19:14:15Z")

</div>

Some possible solutions in this other thread:

> [@Problem to filter dataset](https://forum.inductiveautomation.com/t/problem-to-filter-dataset/77140):
>
> Hello I have this dataset: [image] And I would like filtering row of my dataset where zone =A I want obtain this data below : [image] how can I filtering it please.