I have a table component displaying daily flow totals on each day of the week. It executes an sql query which returns a dataset with each item name as a column and each day as a row. For display purposes I’d like to transpose the rows and columns so that the days are displayed along the top and item names along the side.
I’ve been trying to accomplish this with scripting. It seems such a simple operation but it’s proving much more difficult than I thought. Is it actually possible or does this just contradict the purpose of the table?
*In case you’re interested in what I’ve already done: I converted the dataset to a pyDataSet and transposed it using some of the techniques suggested here. The resulting PyDataSet seems fine but refuses to be converted back into a standard ignition dataset so I can’t display it.