# Can we have a nested property field for a perspective table column?

**URL:** <https://forum.inductiveautomation.com/t/can-we-have-a-nested-property-field-for-a-perspective-table-column/67685>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [December 15, 2022, 5:58pm UTC](https://forum.inductiveautomation.com/t/can-we-have-a-nested-property-field-for-a-perspective-table-column/67685 "2022-12-15T17:58:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Stephane\_Gagnon](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/stephane_gagnon/32/41628_2.png) [@Stephane\_Gagnon](https://forum.inductiveautomation.com/u/Stephane_Gagnon)\
**Post date:** [December 15, 2022, 5:58pm UTC](https://forum.inductiveautomation.com/t/can-we-have-a-nested-property-field-for-a-perspective-table-column/67685/1 "2022-12-15T17:58:25Z")

</div>

Hi,  
I have a simple object like:  
data=[{  
"name" : "Rush",  
"address" :  
{  
"number" : "2112"  
}  
}]  
In my perspective Table I have 2 columns  
First column, field = name  
Second column, field = address.number

Is this possible to do that ? I got no success making this works.

If it's possible, what is the correct syntax ?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/5/9557572f120a0d47a87996257187dbef5ec3187a.png)

---

<div class="post-metadata">

**Author:** ![cmallonee](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmallonee/32/6416_2.png) [@cmallonee](https://forum.inductiveautomation.com/u/cmallonee)\
**Post date:** [December 15, 2022, 6:19pm UTC](https://forum.inductiveautomation.com/t/can-we-have-a-nested-property-field-for-a-perspective-table-column/67685/2 "2022-12-15T18:19:12Z")

</div>

No, the `field` expects a string key which matches either a top-level key in the objects, or a column in the dataset which is in `data`. To use the address number as a column, you'll need to modify the object in use so that the `number` key is at the top level.

Within a transform you could do something _like_ this:

```auto
entries = []
for entry in value:
    entry["number"] = entry["address"]["number"]  
    entries.append(entry)
return entries

```