# Table has limited number of columns?

**URL:** <https://forum.inductiveautomation.com/t/table-has-limited-number-of-columns/101236>\
**Category:** Ignition\
**Tags:** perspective\
**Created:** [January 22, 2025, 4:09pm UTC](https://forum.inductiveautomation.com/t/table-has-limited-number-of-columns/101236 "2025-01-22T16:09:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [January 22, 2025, 4:09pm UTC](https://forum.inductiveautomation.com/t/table-has-limited-number-of-columns/101236/1 "2025-01-22T16:09:23Z")

</div>

Hello!

I got a big query wich results on around 31 columns but I can see only 21 when I bind the named query to a perspectible table.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/a/7a36fefb0eefbf2780f8a06aa94696dd33204c85.png)

Is there a limited number of columns on perspective tables???

Thanks!

---

<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:** [January 22, 2025, 4:11pm UTC](https://forum.inductiveautomation.com/t/table-has-limited-number-of-columns/101236/2 "2025-01-22T16:11:24Z")

</div>

Have you configured `props.columns`? If so, did you only configure 21 entries? (Automatically showing columns only works when there are no columns configured at all.)

Also note that behavior can be flaky if you do not place the dataset column name in `props.columns.N.field`.

---

<div class="post-metadata">

**Author:** ![Alejandro\_Alaco](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/alejandro_alaco/32/59849_2.png) [@Alejandro\_Alaco](https://forum.inductiveautomation.com/u/Alejandro_Alaco)\
**Post date:** [January 22, 2025, 4:12pm UTC](https://forum.inductiveautomation.com/t/table-has-limited-number-of-columns/101236/3 "2025-01-22T16:12:59Z")

</div>

Oh yes, that´s it, I didn´t realize I configured that a while ago. Thanks.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/4/94a7eec8589dbafab7fe41b397b7647b11167e6a.png)