# Perspective Table Alias

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-alias/43735>\
**Category:** Ignition\
**Tags:** perspective, database, ignition80\
**Created:** [February 23, 2021, 4:02pm UTC](https://forum.inductiveautomation.com/t/perspective-table-alias/43735 "2021-02-23T16:02:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![philippe.theroux](https://avatars.discourse-cdn.com/v4/letter/p/7ea924/32.png) [@philippe.theroux](https://forum.inductiveautomation.com/u/philippe.theroux)\
**Post date:** [February 23, 2021, 4:02pm UTC](https://forum.inductiveautomation.com/t/perspective-table-alias/43735/1 "2021-02-23T16:02:21Z")

</div>

Hi,

I am using a named query to populate my table in Perspective. The data in it is fine and I was able to rename the column using for example product\_code AS [Product Code]. Everything was working fine until I enabled Row Selection.  
When Row Selection is enabled, if I click on a row in the table to test, I get 1 error by column telling me wrong Key:  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/d/ad3f652d84de6da0659110268d0f7e5f712d5e68.png)

Am I using Aliases wrong/ is there a way to fix this problem?

Thank you!

---

<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:** [February 23, 2021, 4:46pm UTC](https://forum.inductiveautomation.com/t/perspective-table-alias/43735/2 "2021-02-23T16:46:43Z")

</div>

Object _keys_ should not have spaces in Perspective. Bring in the `product_code` table as-is - then create column configuration objects, which have a key you can use to rename them; see [this page](https://docs.inductiveautomation.com/display/DOC81/Table+Column+Configurations) for more details.