# Easy Chart to Create Table in DB

**URL:** <https://forum.inductiveautomation.com/t/easy-chart-to-create-table-in-db/3118>\
**Category:** Ignition\
**Created:** [July 21, 2011, 10:47pm UTC](https://forum.inductiveautomation.com/t/easy-chart-to-create-table-in-db/3118 "2011-07-21T22:47:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [July 21, 2011, 10:47pm UTC](https://forum.inductiveautomation.com/t/easy-chart-to-create-table-in-db/3118/1 "2011-07-21T22:47:30Z")

</div>

Is it possible to have the Easy Chart create a db table based on the dataset. Sort of like the transaction groups that create a transition group table in the db. That way you could use the table for the dynamic pens etc. Would also enable pen editing/adding columns and the ability to export/import to/from a csv for data manipulation in the dataset.

---

<div class="post-metadata">

**Author:** ![Colby.Clegg](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/colby.clegg/32/3282_2.png) [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\
**Post date:** [July 27, 2011, 3:02pm UTC](https://forum.inductiveautomation.com/t/easy-chart-to-create-table-in-db/3118/2 "2011-07-27T15:02:18Z")

</div>

That’s an interesting request. Many parts of the system are starting to use dataset based configuration, to allow for the possibility of driving the data from a table, but we expect you to make the table by hand. However, it would probably make sense on the sql binding screen to be able to select “new table” instead of an existing table, and have it generate one based on the current columns of the dataset. This could actually work for any dataset, allowing you to define the columns with the UI in the designer, and then create and bind it easily to the db.

We’ll kick it around a bit, but I think it’s a good idea.

Regards,

---

<div class="post-metadata">

**Author:** ![Joseph\_Mendonca](https://avatars.discourse-cdn.com/v4/letter/j/58f4c7/32.png) [@Joseph\_Mendonca](https://forum.inductiveautomation.com/u/Joseph_Mendonca)\
**Post date:** [July 29, 2011, 12:57am UTC](https://forum.inductiveautomation.com/t/easy-chart-to-create-table-in-db/3118/3 "2011-07-29T00:57:14Z")

</div>

Thanks for considering the possibility. Would it also be able fill the table columns with the pens created in the easy chart configuration as well?