# Bug with addColumn and None values

**URL:** <https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116>\
**Category:** Ignition\
**Created:** [February 23, 2018, 9:22pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116 "2018-02-23T21:22:12Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![boandersen](https://avatars.discourse-cdn.com/v4/letter/b/13edae/32.png) [@boandersen](https://forum.inductiveautomation.com/u/boandersen)\
**Post date:** [February 23, 2018, 9:22pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116/1 "2018-02-23T21:22:12Z")

</div>

if an int column that has None values is added to a dataset using system.dataset.addColumn, the result is unexpected:

```auto
ds = system.dataset.toDataSet(['Col1'],[[1],[5],[4],[3],[2],[6]])
newCol = [None, None, None, 5, None, 1]
ds = system.dataset.addColumn(ds, newCol, 'Col2', int)
for i in range(0, ds.rowCount):
	print i, ds.getValueAt(i,0), ds.getValueAt(i,1)

```

the result is

```auto
0 1 None
1 5 None
2 4 None
3 3 5
4 2 5
5 6 1

```

It appears that once a non-None value is encountered, this value is repeated instead of subsequent None values until a new non-None is encountered.

---

<div class="post-metadata">

**Author:** ![boandersen](https://avatars.discourse-cdn.com/v4/letter/b/13edae/32.png) [@boandersen](https://forum.inductiveautomation.com/u/boandersen)\
**Post date:** [March 5, 2018, 7:50pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116/2 "2018-03-05T19:50:00Z")

</div>

I was hoping for a response from Ignition.

---

<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:** [March 5, 2018, 8:01pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116/3 "2018-03-05T20:01:35Z")

</div>

I suggest opening a ticket with support.

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [March 5, 2018, 9:11pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116/4 "2018-03-05T21:11:25Z")

</div>

Like Phil said. Inductive Automation employees only monitor the forum randomly, and it was just chance that I looked at this post today (and only because we just did a unit test for this script function).

I’ll go ahead and file a bug ticket for this, but you’ll normally get much faster response by calling or emailing support. Even if you don’t have a support contract, you can always report bugs to them.

---

<div class="post-metadata">

**Author:** ![danFromNj](https://avatars.discourse-cdn.com/v4/letter/d/76d3ee/32.png) [@danFromNj](https://forum.inductiveautomation.com/u/danFromNj)\
**Post date:** [December 27, 2019, 5:39pm UTC](https://forum.inductiveautomation.com/t/bug-with-addcolumn-and-none-values/17116/5 "2019-12-27T17:39:40Z")

</div>

Does anyone know if this bug has been addressed?

EDIT  
Nevermind, I found another thread that came after this thread.  
[http://forum.inductiveautomation.com/t/system-dataset-addcolumn-bug/17558](http://forum.inductiveautomation.com/t/system-dataset-addcolumn-bug/17558)

The bug seems to have been addressed in version 7.9.8.