# Perspective 8.1.3 Table Sorting when Headers are numbers **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [December 5, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230 "2022-12-05T14:41:24Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![byrcharl](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@byrcharl](https://forum.inductiveautomation.com/u/byrcharl)\ **Post date:** [December 5, 2022, 2:41pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/1 "2022-12-05T14:41:24Z")
Im Looking for a way to remove all sorting on a table and display data as per the query results. Im find even if i define the columns in order it still wants to put the settings column to the far right. I need the settings column on the left. The data is parsed with external script from multiple websites and added to mysql tables. Query Results: ![2022-12-05_6-24-09](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/9/c924a9251e9681fc8c23c9fae8096ac4926c323a.png) Table Auto sorting for some reason: ![2022-12-05_6-25-50](https://us1.discourse-cdn.com/inductiveautomation/original/3X/e/b/eb7a5cf275a37bdaf2b5ab0d79e9e87e1eb61a52.png) ---
**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:** [December 5, 2022, 2:45pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/2 "2022-12-05T14:45:41Z")
In your columns property, are you exactly matching the case of the data's column names? ---
**Author:** ![byrcharl](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@byrcharl](https://forum.inductiveautomation.com/u/byrcharl)\ **Post date:** [December 5, 2022, 2:51pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/3 "2022-12-05T14:51:09Z")
Yes ---
**Author:** ![byrcharl](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@byrcharl](https://forum.inductiveautomation.com/u/byrcharl)\ **Post date:** [December 5, 2022, 2:53pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/4 "2022-12-05T14:53:34Z")
![2022-12-05_6-53-01](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/b/0b8e2aa4d6e262138bb297383881311bb42d7cee.png) ---
**Author:** ![byrcharl](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@byrcharl](https://forum.inductiveautomation.com/u/byrcharl)\ **Post date:** [December 5, 2022, 3:00pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/5 "2022-12-05T15:00:18Z")
Ok i think i got it. i didnt see it was putting a , in the number ---
**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:** [December 5, 2022, 3:04pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/6 "2022-12-05T15:04:07Z")
I think you are going to keep running into trouble as long as your column names can be interpreted as numbers. ---
**Author:** ![byrcharl](https://avatars.discourse-cdn.com/v4/letter/b/e79b87/32.png) [@byrcharl](https://forum.inductiveautomation.com/u/byrcharl)\ **Post date:** [December 5, 2022, 3:06pm UTC](https://forum.inductiveautomation.com/t/perspective-8-1-3-table-sorting-when-headers-are-numbers/67230/7 "2022-12-05T15:06:15Z")
Yes i think so aswell . It was a pain with mysql as the table names are the numbers i needed ``. I put a generic name infront of the number hopefully it will help . thanks for your help