# Table layout **URL:** \ **Category:** Ignition\ **Created:** [April 6, 2011, 9:41pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848 "2011-04-06T21:41:58Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Henry](https://avatars.discourse-cdn.com/v4/letter/h/df705f/32.png) [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Post date:** [April 6, 2011, 9:41pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/1 "2011-04-06T21:41:58Z")
I have a query that is filling a table. Can the table be made to display the data top to bottom or one column with many rows, instead of left to right one row with many columns? ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [April 6, 2011, 9:49pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/2 "2011-04-06T21:49:08Z")
I think you could use a pivot function in your sql query. ---
**Author:** ![Henry](https://avatars.discourse-cdn.com/v4/letter/h/df705f/32.png) [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Post date:** [April 7, 2011, 5:47pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/3 "2011-04-07T17:47:46Z")
Do you know if a pivot function will work with the built in IA table component? ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [April 7, 2011, 6:32pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/4 "2011-04-07T18:32:36Z")
You either have to find a database function to flip the results or flip them manually in Python scripting. Which database are you using? ---
**Author:** ![Henry](https://avatars.discourse-cdn.com/v4/letter/h/df705f/32.png) [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Post date:** [April 7, 2011, 6:43pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/5 "2011-04-07T18:43:21Z")
My SQL ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [April 7, 2011, 10:29pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/6 "2011-04-07T22:29:50Z")
Well, it looks like you either have to create a stored procedure in MySQL to perform that function or use Python scripting in Ignition. In either case you have to get the data, loop through the rows and create a new result set out of it. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [April 11, 2011, 5:49pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/7 "2011-04-11T17:49:22Z")
Travis, can you give us an example of doing it in python? for example, we have a table with two columns of data, one being apples and one being oranges, along with a timestamp column. Lets say that we want apples to be on one row and oranges on the next, and then have columns for each day of the month that show the amount of apples/oranges for each day. ---
**Author:** ![Travis.Cox](https://avatars.discourse-cdn.com/v4/letter/t/b9bd4f/32.png) [@Travis.Cox](https://forum.inductiveautomation.com/u/Travis.Cox)\ **Post date:** [April 11, 2011, 6:23pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/8 "2011-04-11T18:23:52Z")
Sure, here is an example. Table 1 has three columns: Apples, Oranges, Timestamp. The following script will loop through the dataset creating a new one that is flipped:[code]data = system.dataset.toPyDataSet(event.source.parent.getComponent(‘Table 2’).data) newData = header = [“Label”] col1Data = [“Apples”] col2Data = [“Oranges”] for row in data: label = system.db.dateFormat(row[“Timestamp”], “yyyy-MM-dd”) header.append(label) col1Data.append(row[“Apples”]) col2Data.append(row[“Oranges”]) newData.append(col1Data) newData.append(col2Data) event.source.parent.getComponent(‘Table 3’).data = system.dataset.toDataSet(header, newData)[/code]Here is a picture: ![](https://us1.discourse-cdn.com/inductiveautomation/original/1X/8328e136549adc76484b59795e14e05afb5db656.jpg) I have also attached a window for you to look at .[Convert.vwin](https://us1.discourse-cdn.com/inductiveautomation/original/1X/a210bed2ec387b7dd0ee6e4369be7056eeccf681.vwin) (10.6 KB)Hope this helps. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [April 11, 2011, 7:05pm UTC](https://forum.inductiveautomation.com/t/table-layout/2848/9 "2011-04-11T19:05:35Z")
sweet! ---
**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\ **Post date:** [April 16, 2011, 12:18am UTC](https://forum.inductiveautomation.com/t/table-layout/2848/10 "2011-04-16T00:18:44Z")
This problem is [an](http://www.inductiveautomation.com/forum/viewtopic.php?f=23&t=4838&p=10622&hilit=turn+side#p10622) [old](http://www.inductiveautomation.com/forum/viewtopic.php?f=23&t=3649&p=6288&hilit=turn+side#p6288) [one](http://www.inductiveautomation.com/forum/viewtopic.php?f=23&t=760&hilit=turn+side).