# Power Table Row Separators

**URL:** <https://forum.inductiveautomation.com/t/power-table-row-separators/15946>\
**Category:** Ignition\
**Created:** [November 9, 2017, 2:15pm UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946 "2017-11-09T14:15:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![cmisztur2](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmisztur2/32/4243_2.png) [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\
**Post date:** [November 9, 2017, 2:15pm UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946/1 "2017-11-09T14:15:16Z")

</div>

I am displaying data for multiple machines in a single table. I would like to visually split the rows by machine by introducing a row that spans across all columns and has the machine name as the text. What are my options?

![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/3/3a49cd63c18e9425f190da483ebb467af2a1d409.png)

---

<div class="post-metadata">

**Author:** ![cmisztur2](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmisztur2/32/4243_2.png) [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\
**Post date:** [November 9, 2017, 3:48pm UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946/2 "2017-11-09T15:48:04Z")

</div>

perfect…

```auto
        spanHeaders = ['row','column','width','height']
		spanData = []
		
		rowIndex = 0
		for wc in wcDs.getUnderlyingDataset().getColumnAsList(0):
			ctl = {'type':'WC','data':wc}
			data.append([system.util.jsonEncode(ctl),'','','','',''])
			spanData.append([rowIndex,1,5,1])
			rowIndex+=1
			for i in range(0,3):
				ctl2 = {'type':'DATA'}
				data.append([system.util.jsonEncode(ctl2),'test1','test2','test3','test4','test5'])
				rowIndex+=1
				
		self.setCellSpanData(system.dataset.toDataSet(spanHeaders, spanData))

```

---

<div class="post-metadata">

**Author:** ![bvaldovinos](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bvaldovinos/32/6315_2.png) [@bvaldovinos](https://forum.inductiveautomation.com/u/bvaldovinos)\
**Post date:** [October 4, 2018, 11:39pm UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946/3 "2018-10-04T23:39:20Z")

</div>

@cmisztur2 Thanks for sharing your code. Where did you find out that the method “getColumnAsList(0)” was available for “getUnderlyingDataset()”

---

<div class="post-metadata">

**Author:** ![cmisztur2](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/cmisztur2/32/4243_2.png) [@cmisztur2](https://forum.inductiveautomation.com/u/cmisztur2)\
**Post date:** [October 5, 2018, 1:18am UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946/4 "2018-10-05T01:18:35Z")

</div>

> [@bvaldovinos](#):
>
> getColumnAsList

Hmmm, good question. I thought maybe in the docs: [ignition 7.9.4-beta1 API](http://files.inductiveautomation.com/sdk/javadoc/ignition79/794-beta1/index.html)  
but maybe I did a dir on the object to list attributes...

---

<div class="post-metadata">

**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:** [October 5, 2018, 2:04am UTC](https://forum.inductiveautomation.com/t/power-table-row-separators/15946/5 "2018-10-05T02:04:20Z")

</div>

Most datasets you encounter in the designer or client are instances of a [AbstractDataset](http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/ignition/common/AbstractDataset.html), which extends the [Dataset](http://files.inductiveautomation.com/sdk/javadoc/ignition79/795/com/inductiveautomation/ignition/common/Dataset.html) interface to include that method.
