# Record in a single table SQL cumulative data

**URL:** <https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616>\
**Category:** Ignition\
**Created:** [June 6, 2019, 4:17pm UTC](https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616 "2019-06-06T16:17:36Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![adominguez](https://avatars.discourse-cdn.com/v4/letter/a/bb73d2/32.png) [@adominguez](https://forum.inductiveautomation.com/u/adominguez)\
**Post date:** [June 6, 2019, 4:17pm UTC](https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616/1 "2019-06-06T16:17:36Z")

</div>

Hi guys, when you create an historian Tag, the Tag is recorded in a series of tables that are chronically sorted.

![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/a/a6cca285eef8734d7c72331ce9d6e780dc9c83e1.png)

I want sqlt\_data tables in a single one, but I can’t configure in the Tag properties.

How can I record SQL historian in a single table for a number of tag as fields sorted by the timestamp?  
in my case, PM5300 with the fields: Energy, Power, Pf, THD’s etc

Regards

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [June 6, 2019, 4:30pm UTC](https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616/2 "2019-06-06T16:30:46Z")

</div>

To go that way, it might be worth considering using transaction groups and generating your own table. The data won’t be as compressed in the long term though.

You can minimize the number of the historian tables by setting your historian partition length for your tag history settings, but they still will generate at a set interval.

---

<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:** [June 7, 2019, 5:38pm UTC](https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616/3 "2019-06-07T17:38:00Z")

</div>

> [@adominguez](#):
>
> How can I record SQL historian in a single table for a number of tag as fields sorted by the timestamp?  
> in my case, PM5300 with the fields: Energy, Power, Pf, THD’s etc

This is _ **exactly** _ what transaction groups are designed to do.

---

<div class="post-metadata">

**Author:** ![adominguez](https://avatars.discourse-cdn.com/v4/letter/a/bb73d2/32.png) [@adominguez](https://forum.inductiveautomation.com/u/adominguez)\
**Post date:** [June 14, 2019, 8:18pm UTC](https://forum.inductiveautomation.com/t/record-in-a-single-table-sql-cumulative-data/25616/4 "2019-06-14T20:18:15Z")

</div>

@grietveld, @pturmel Thanks once again! from a noob.