# What transaction Group type to use for such purpose?

**URL:** <https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767>\
**Category:** Ignition\
**Tags:** database\
**Created:** [December 23, 2020, 8:38pm UTC](https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767 "2020-12-23T20:38:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dtran](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dtran](https://forum.inductiveautomation.com/u/dtran)\
**Post date:** [December 23, 2020, 8:38pm UTC](https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767/1 "2020-12-23T20:38:04Z")

</div>

Let’s say I have 2 tags val1 and val2, both initiated with value of 5. val1 changes value at 00:00 and again at 00:10, then val2 changes value at 00:20. I will then have this table at Database:

|time\_stamp | val1 | val2|  
|00:00 |5 |5 |  
|00:10 |9 |5 |  
|00:20 |9 |9 |

What kind of transaction group, and set up, should I use to have below table instead?

|time\_stamp | val\_index | value|  
|00:00 |1 |5 |  
|00:00 |2 |5 |  
|00:10 |1 |9 |  
|00:20 |2 |9 |

---

<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:** [December 23, 2020, 8:40pm UTC](https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767/2 "2020-12-23T20:40:35Z")

</div>

Use the regular tag historian instead of a transaction group. The tag historian uses “tall” format with tag IDs.

---

<div class="post-metadata">

**Author:** ![dtran](https://avatars.discourse-cdn.com/v4/letter/d/e36b37/32.png) [@dtran](https://forum.inductiveautomation.com/u/dtran)\
**Post date:** [December 23, 2020, 9:03pm UTC](https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767/3 "2020-12-23T21:03:31Z")

</div>

Thanks pturmel for the response. Transaction Group also offer feature to log multiple tags on value change of 1 (or more) tag. As far as i understand, Historian can only log tag based on its value change. Is there any work around to Historian based on other tag value change?

---

<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:** [December 23, 2020, 9:06pm UTC](https://forum.inductiveautomation.com/t/what-transaction-group-type-to-use-for-such-purpose/41767/4 "2020-12-23T21:06:53Z")

</div>

Your example of “tall” shows only one value being recorded for the latter changes. That is what the tag historian will do. A SQL Bridge transaction group logs multiple values together with a single timestamp. The two approaches are fundamentally different. Use each where you need them.