# Change Order of Columns in Table View

**URL:** <https://forum.inductiveautomation.com/t/change-order-of-columns-in-table-view/8353>\
**Category:** Ignition\
**Created:** [April 23, 2014, 3:36pm UTC](https://forum.inductiveautomation.com/t/change-order-of-columns-in-table-view/8353 "2014-04-23T15:36:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [April 23, 2014, 3:36pm UTC](https://forum.inductiveautomation.com/t/change-order-of-columns-in-table-view/8353/1 "2014-04-23T15:36:24Z")

</div>

I am getting a table view from a Stored Procedure, but for some reason the columns are out of order…

Measurement 1, Measurement 10, Measurement 11, Measurement 12… Measurement 19, Measurement 2.

Obviously I want Measurement 1, Measurement 2, measurement 3, etc. Is there a way to do this with the Table Customizer??

---

<div class="post-metadata">

**Author:** ![adamaustin](https://avatars.discourse-cdn.com/v4/letter/a/5f8ce5/32.png) [@adamaustin](https://forum.inductiveautomation.com/u/adamaustin)\
**Post date:** [April 28, 2014, 2:24pm UTC](https://forum.inductiveautomation.com/t/change-order-of-columns-in-table-view/8353/2 "2014-04-28T14:24:45Z")

</div>

Here is some code I wrote to swap columns in a PyDataSet:

[code]#############################################################################################################################

# 

# sortColumnOrderListData(listdata, listcolumnsortorder)

# Update the listdata columns based on the listcolumnsortorder.

# Super fast way to swap columns in memory.

# 

# listdata - the PyDataSet that we will use and retuen with the columns swapped

# 

# listcolumnsortorder - the sort order, this should be a PySequence of numbers

# 

# 

# Example:

# 

# l = [[“test”, “this”, “a”, “only”, “is”], [“fast”, “wow!”, “was”, “really”, “it”]

# o = [4, 0, 3, 2, 1]

# l = app.listconfig.sortColumnOrderListData(l, o)

# #l = [[“this”, “is”, “only”, “a”, “test”], [“wow!”, “it”, “really”, “was”, “fast”]

def sortColumnOrderListData(listdata, listsortorder):  
#AJA (2013-08-29) RM#436 add global for ordering columns  
global sortColumnOrderListDataResults

```
sortColumnOrderListDataResults = [row for row in listdata]
sortColumnOrderListDataResults.append(listsortorder)
resultsTransposed = zip(*sortColumnOrderListDataResults)
resultsTransposed = sorted(resultsTransposed, key=lambda x: x[len(sortColumnOrderListDataResults)-1])
results = zip(*resultsTransposed)
results = results[0:-1]
resultsTmp = results
results = []
for row in resultsTmp:
	resultRow = []
	for val in row:
		resultRow.append(val)
	results.append(resultRow)
return results

```

[/code]

---

<div class="post-metadata">

**Author:** ![anna](https://avatars.discourse-cdn.com/v4/letter/a/779978/32.png) [@anna](https://forum.inductiveautomation.com/u/anna)\
**Post date:** [May 14, 2014, 7:15pm UTC](https://forum.inductiveautomation.com/t/change-order-of-columns-in-table-view/8353/3 "2014-05-14T19:15:11Z")

</div>

tbackus, what is the column order returned when you run this stored procedure outside of Ignition?