# Set column values dataset

**URL:** <https://forum.inductiveautomation.com/t/set-column-values-dataset/10208>\
**Category:** Ignition\
**Created:** [July 9, 2015, 8:26pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208 "2015-07-09T20:26:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AJBerera](https://avatars.discourse-cdn.com/v4/letter/a/9fc29f/32.png) [@AJBerera](https://forum.inductiveautomation.com/u/AJBerera)\
**Post date:** [July 9, 2015, 8:26pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208/1 "2015-07-09T20:26:03Z")

</div>

I have a script that will set a dataset that is populated by running queries.  
starting with query 1:

```auto
      day = "some date"
      resultsPy1 = system.db.runQuery(query1)
      resultsData1 = system.dataset.toDataSet(resultsPy1)
      editData = system.dataset.setValue(resultsData1, -1, "Date", day)
```

But I am trying to change all of the Date column rows to a particular date value.  
I noticed there are a few methods of setting values, but would like to find a simple solution to set every row in my column, even perhaps without using a loop.

Any suggestions?

---

<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:** [July 9, 2015, 8:56pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208/2 "2015-07-09T20:56:16Z")

</div>

Sorry, you need a loop,overwriting ‘editData’ every time…`from java.util import Date
day = Date.parse("some date")
resultsPy1 = system.db.runQuery(query1)
editData = system.dataset.toDataSet(resultsPy1)
idx = editData.getColumnIndex("Date")
for r in range(editData.rowCount):
  editData = system.dataset.setValue(editData, r, idx, day)`Using the column index instead of the column name will speed it up some for large datasets.

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [July 9, 2015, 9:22pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208/3 "2015-07-09T21:22:27Z")

</div>

If you are going to replace the date of all the rows being returned, just pass in the date you want.

[code]import datetime

today = datetime.datetime.now()

query = “”"  
SELECT CAST(? AS DATETIME) AS ‘tstamp’, col1, col2, col3  
FROM mytable  
“”"  
result = system.db.runPrepQuery(query,[today])[/code]

---

<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:** [July 9, 2015, 9:45pm UTC](https://forum.inductiveautomation.com/t/set-column-values-dataset/10208/4 "2015-07-09T21:45:02Z")

</div>

[quote=“jpark”]just pass in the date you want.[/quote] /me slaps forehead ![:prayer:](https://us1.discourse-cdn.com/inductiveautomation/original/1X/e5a7e3b63facc151ea73e3b45db7bdb3d4bdc316.gif ":prayer:")