# Pulling column value from a Perspective table

**URL:** <https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [November 28, 2022, 11:30am UTC](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966 "2022-11-28T11:30:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![christopher\_wray](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@christopher\_wray](https://forum.inductiveautomation.com/u/christopher_wray)\
**Post date:** [November 28, 2022, 11:30am UTC](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966/1 "2022-11-28T11:30:00Z")

</div>

Hi sorry for the noob question. If I have a perspective table component, with a query binding on it. and I wanted to get the value of one of the columns returned from the query.

Can you get that information from one of the Properties ? I guess it has something to do with the data property below selection and then you have to add objects or arrays or something. sorry bit clueless and brain not working today. I know you get it obviously by scripting

---

<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:** [November 28, 2022, 12:22pm UTC](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966/2 "2022-11-28T12:22:47Z")

</div>

If it's a dataset, you can use `ds.getColumnAsList(x)` where `ds` is your dataset and `x` is the column index (starting from 0).

So you can create a custom property, bind it to your table's `.data` prop, add a script transform and return `value.getColumnAsList(i)`.

If it's not a dataset, but an object (you chose `json` as the return format in your query binding), you can use this instead:

```python
return [row['column_name'] for row in value]

```

---

<div class="post-metadata">

**Author:** ![christopher\_wray](https://avatars.discourse-cdn.com/v4/letter/c/54ee81/32.png) [@christopher\_wray](https://forum.inductiveautomation.com/u/christopher_wray)\
**Post date:** [November 28, 2022, 12:30pm UTC](https://forum.inductiveautomation.com/t/pulling-column-value-from-a-perspective-table/66966/3 "2022-11-28T12:30:17Z")

</div>

thank you pascal