# Perspective Table, dataset help

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [December 6, 2021, 8:59pm UTC](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816 "2021-12-06T20:59:44Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![victordcq](https://avatars.discourse-cdn.com/v4/letter/v/f6c823/32.png) [@victordcq](https://forum.inductiveautomation.com/u/victordcq)\
**Post date:** [December 7, 2021, 8:01am UTC](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816/2 "2021-12-07T08:01:24Z")

</div>

The whole row or just the one cell?

if you set your query to get json format  
you can change the enter to have value and style. look at the table the first cell is orange, you can do the same for the whole row.  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/6/4634d8c597eaf51ab4f694802232219a05a6b023.png)

some script inspiration:

> [@Perspective table cell color](https://forum.inductiveautomation.com/t/perspective-table-cell-color/50047/4):
>
> it might be easier to use “getColumnNames()” instead of “getColumnCount()”, so you dont have to worry about sorting indexes this: for col in value.getColumnNames(): .... if col == 'LED': ... row\_object[col]=cell\_object instead of: for col in range(value.getColumnCount()): ... value.getColumnName(col) == 'LED' ... row\_object[value.getColumnName(col)]=cell\_object

---

_[View the full topic](https://forum.inductiveautomation.com/t/perspective-table-dataset-help/53816)._