# Show Only "True" Rows in Perspective Table

**URL:** <https://forum.inductiveautomation.com/t/show-only-true-rows-in-perspective-table/72362>\
**Category:** Ignition\
**Tags:** scripting, perspective\
**Created:** [April 12, 2023, 3:31pm UTC](https://forum.inductiveautomation.com/t/show-only-true-rows-in-perspective-table/72362 "2023-04-12T15:31:09Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [April 12, 2023, 4:17pm UTC](https://forum.inductiveautomation.com/t/show-only-true-rows-in-perspective-table/72362/3 "2023-04-12T16:17:39Z")

</div>

One of many options:

```python
def transform(self, value, quality, timestamp):
	in_range_values = 0
	out_of_range_indices = []
	colCount = value.getColumnCount()
	for row in range(value.getRowCount()):
		if 16 < value.getValueAt(row,1) < 27:
			in_range_values += 1
		else:	
			out_of_range_indices.append(row)
	rowsRemoved = system.dataset.deleteRows(value, out_of_range_indices)
	newDataset = system.dataset.addColumn(rowsRemoved, colCount, in_range_values, "results", bool)	
	return newDataset

```

[Ignition Extensions](https://forum.inductiveautomation.com/t/ignition-extensions-convenience-utilities-for-advanced-users/64615#systemdatasetfilterdataset-filter-dataset-9), my free convenience function module, also adds a `system.dataset.filter` function, so you could rewrite your code as:

```python
def transform(self, value, quality, timestamp):
	in_range_values = []
	colCount = value.getColumnCount()
	for row in range(value.getRowCount()):
		in_range_values.append(16 < value.getValueAt(row,1) < 27)
	addedColumn = system.dataset.addColumn(rowsRemoved, colCount, in_range_values, "results", bool)
	newDataset = system.dataset.filter(addedColumn, lambda **columns: columns["results"])
	return newDataset

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/show-only-true-rows-in-perspective-table/72362)._