# Multiply dataset columns with number

**URL:** <https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258>\
**Category:** Ignition\
**Created:** [May 29, 2023, 12:00pm UTC](https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258 "2023-05-29T12:00:37Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\
**Post date:** [May 29, 2023, 12:37pm UTC](https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258/6 "2023-05-29T12:37:05Z")

</div>

That doesn't seem too bad for scripting. Try something like this:

```auto
table = event.source.parent.getComponent('Power Table')
#KWdataset = system.tag.queryTagHistory([...])
if isMMBTU:
	KWtoMMBTU_Multiplier = 3
	headers = system.dataset.getColumnHeaders(KWdataset)
	data = [[KWdataset.getValueAt(row, column) if column < 2 else KWdataset.getValueAt(row, column) * KWtoMMBTU_Multiplier 
				for column in range(KWdataset.columnCount)]
			for row in range(KWdataset.rowCount)]
	MMBTUDataset = system.dataset.toDataSet(headers, data)
	table.data = MMBTUDataset
else:
	table.data = KWdataset

```

**Edit:** Updated code to reflect the purpose of multiplying columns 2, 3, and 4 by 3

---

_[View the full topic](https://forum.inductiveautomation.com/t/multiply-dataset-columns-with-number/74258)._