# Single Column Transaction Groups **URL:** \ **Category:** Ignition\ **Created:** [March 11, 2014, 9:50pm UTC](https://forum.inductiveautomation.com/t/single-column-transaction-groups/8143 "2014-03-11T21:50:25Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![bridress](https://avatars.discourse-cdn.com/v4/letter/b/65b543/32.png) [@bridress](https://forum.inductiveautomation.com/u/bridress)\ **Post date:** [March 11, 2014, 9:50pm UTC](https://forum.inductiveautomation.com/t/single-column-transaction-groups/8143/1 "2014-03-11T21:50:25Z")
Hello, I’m trying to create a block (or standard) transaction group that will write a group of tags on a set schedule to a table I define. I need one value column to store the floating point values. There will be two other columns: One tag\_ID and one tag\_TimeStamp column. It seems that when I setup transaction groups it wants the tags from OPC to be written to it’s own distinct column. The problem is we have a data warehouse that connects to this table via a dataview and it must be scalable across multiple sites running Ignition platform. It would be virtually impossible to have thousands of separate columns for this data. I would rather query by TagID. Am I missing something on a way to make this happen? I guess I could have a separate Transaction group for each tag but this seems inefficient and difficult to manage. ---
**Author:** ![diat150](https://avatars.discourse-cdn.com/v4/letter/d/a587f6/32.png) [@diat150](https://forum.inductiveautomation.com/u/diat150)\ **Post date:** [March 12, 2014, 12:06am UTC](https://forum.inductiveautomation.com/t/single-column-transaction-groups/8143/2 "2014-03-12T00:06:02Z")
you need to use block group, and then tell it to insert new block under action\>table action. that will make the transaction group store the data in a narrow format. also you have to tell it to insert the rowid, which is the row the tag is in in your list of tags. Thats the only way I have found to identify the data in the table by.