Transpose List of Objects

Ignition
1

Hello. I am new to Ignition and I have a question; how do I transpose the columns/rows of a table. I have a list objects that I am trying to display in the table.
.

Table
Table1413×848 89 KB

2

How is the data populating now? Likely a script transform would be the best option.

EDIT: Also, will the ‘header’ names also appear in a column, with values in a second column?

3

Right now the value name is displayed in the Header and the value is displayed in the Row. For example, AF_AcidTempA is in the header and the corresponding value is in the row. Yes, I would want the header names to appear in the 1st column and values in the 2nd column.

4

Let me be more clear. How is the data getting into the table?

5

I have the session custom property AcidFarm folder binded to the Table data object 0.

binding
binding1563×737 105 KB

6

Bind it to props.data instead of props.data[0]. Then add a script transform (located under the binding settings):

	newList = []
	for key in sorted(value.keys()):
		obj = {'name':{'value':key}, 'setting':{'value':value[key]}}
		newList.append(obj)
	return newList

image
image973×801 61.4 KB

7

Works great! Thank you so much!

1 Like