# Perspective Table Invalid Keys

**URL:** <https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796>\
**Category:** Ignition\
**Tags:** ignition81, perspective\
**Created:** [May 19, 2022, 5:24pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796 "2022-05-19T17:24:01Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [May 19, 2022, 5:24pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/1 "2022-05-19T17:24:01Z")

</div>

I have a somewhat complicated perspective table with a subview and footer groups. There are no red marks in the table. No issues in the columns nor footer groups nor subview.

I can’t find a single error and yet I have “Invalid Keys”. Why?

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/3/83679cbca320f626435d5357e1d309c1ff8edcdc.jpeg)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [May 19, 2022, 5:26pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/2 "2022-05-19T17:26:08Z")

</div>

Do the column names in your dataset start with digits?

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [May 19, 2022, 6:51pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/3 "2022-05-19T18:51:27Z")

</div>

No, they are string values. The props.columns.0.field value is has the correct string as the filter and controls are tied to the column in the table.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 19, 2022, 7:05pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/4 "2022-05-19T19:05:17Z")

</div>

> [@jcaudle](#):
>
> No, they are string values.

Phil's question wasn't whether or not they were string values. It was "_Do the column names in your dataset start with digits?_"

e.g. `2022_results`, etc.

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [May 19, 2022, 7:17pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/5 "2022-05-19T19:17:43Z")

</div>

Still no.

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

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 19, 2022, 7:25pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/6 "2022-05-19T19:25:37Z")

</div>

I see `%` characters in there. Are they the problem?

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [May 19, 2022, 7:33pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/7 "2022-05-19T19:33:47Z")

</div>

Same 20 count of “Invalid Key” with all the special characters removed from the dataset column headers

---

<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:** [May 19, 2022, 7:42pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/8 "2022-05-19T19:42:39Z")

</div>

When you say “special characters” are you including spaces? Perspective does not like spaces in key names. I don’t think this warning should impact your use of the Table or your data.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 19, 2022, 7:44pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/9 "2022-05-19T19:44:14Z")

</div>

Hmmm, the errors disappear when I test it with the spaces replaced with underscores and ‘%’ characters removed.

---

<div class="post-metadata">

**Author:** ![jcaudle](https://avatars.discourse-cdn.com/v4/letter/j/35a633/32.png) [@jcaudle](https://forum.inductiveautomation.com/u/jcaudle)\
**Post date:** [May 20, 2022, 5:57pm UTC](https://forum.inductiveautomation.com/t/perspective-table-invalid-keys/59796/10 "2022-05-20T17:57:40Z")

</div>

I was not including spaces in my “special characters” but, I changed my query, updating all spaces to underscores, likewise in the perspective table columns and footers and the 20 invalid keys are still there.
