# "Hiding" A Column in a chart, much like a table

**URL:** <https://forum.inductiveautomation.com/t/hiding-a-column-in-a-chart-much-like-a-table/7820>\
**Category:** Ignition\
**Created:** [January 13, 2014, 1:50pm UTC](https://forum.inductiveautomation.com/t/hiding-a-column-in-a-chart-much-like-a-table/7820 "2014-01-13T13:50:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tbackus](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tbackus/32/5091_2.png) [@tbackus](https://forum.inductiveautomation.com/u/tbackus)\
**Post date:** [January 13, 2014, 1:50pm UTC](https://forum.inductiveautomation.com/t/hiding-a-column-in-a-chart-much-like-a-table/7820/1 "2014-01-13T13:50:09Z")

</div>

Is is possible to “hide” a column of data from a chart… I know this sounds dumb, but I was given a Stored Procedure with wich to generate a chart from our SQL Admin, and unfortunately he is giving me one too many columns of information back. I know the best and ultimate solution is to have him fix his stored procedure, but his boss moved him to a new project and it will be a while til he will be able to fix the stored procedure.

So I just need to hide one column of data, is it possible??

---

<div class="post-metadata">

**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\
**Post date:** [January 13, 2014, 2:18pm UTC](https://forum.inductiveautomation.com/t/hiding-a-column-in-a-chart-much-like-a-table/7820/2 "2014-01-13T14:18:46Z")

</div>

one thing you can do is to take the dataset that gets returned from the stored procedure and then write a script that runs thru that dataset and generates a new dataset that doesnt include that column. here is a quick example of taking a query that has 3 columns and dropping one of the columns and creating a new dataset.

```auto
ds = system.db.runQuery("SELECT devicename, displayname,unitid FROM devices")
newDS = []
headers = ["devicename", "displayname"]
for row in ds:
	devicename = row[0] 
	displayname = row[1]
	newDS.append([devicename,displayname])
print newDS
event.source.parent.getComponent('Table').data = system.dataset.toDataSet(headers, newDS)
```