# Transaction groups, block group, item data type dataset **URL:** \ **Category:** Ignition\ **Created:** [March 16, 2020, 9:38pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143 "2020-03-16T21:38:15Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![maja](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@maja](https://forum.inductiveautomation.com/u/maja)\ **Post date:** [March 16, 2020, 9:38pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/1 "2020-03-16T21:38:15Z")
Hi to All, I am sorry if this question already exists, I couldn’t find it. I have a memory tag which data type is dataset (two columns and xx rows). I wont to use transaction groups as I will insert data from dataset tag in SQL database (table with 2 columns). Is it possible? I have tried a lot of different configurations and I didn’t succeed. Thanks! ---
**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:** [March 16, 2020, 10:34pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/2 "2020-03-16T22:34:56Z")
You cannot do this. Datasets cannot be stored to history nor included in a transaction group. If you must record a dataset, you will have to write a custom script to insert its contents to the DB row by row. ---
**Author:** ![maja](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@maja](https://forum.inductiveautomation.com/u/maja)\ **Post date:** [March 16, 2020, 10:38pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/3 "2020-03-16T22:38:18Z")
Ok. Thank you very much on your answer. I am not surprised, but possibility to set data type to Data Set made me think that is possible. Thanks! ---
**Author:** ![maja](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@maja](https://forum.inductiveautomation.com/u/maja)\ **Post date:** [March 17, 2020, 3:00pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/4 "2020-03-17T15:00:32Z")
But with block group I do not have to insert row by row in DB I can insert an Array, for example of strings? ---
**Author:** ![Carlos\_Villanueva\_He](https://avatars.discourse-cdn.com/v4/letter/c/7bcc69/32.png) [@Carlos\_Villanueva\_He](https://forum.inductiveautomation.com/u/Carlos_Villanueva_He)\ **Post date:** [October 28, 2022, 10:01pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/5 "2022-10-28T22:01:08Z")
Did you figured it out? I having the same question. I wish there was a system.db function to do a block transfer. ---
**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:** [October 28, 2022, 10:04pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/6 "2022-10-28T22:04:15Z")
You can construct multi-row insert statements in scripts if your DB supports such syntax. The key is making sure the final list of arguments matches the number of substitution points in your SQL. ---
**Author:** ![Carlos\_Villanueva\_He](https://avatars.discourse-cdn.com/v4/letter/c/7bcc69/32.png) [@Carlos\_Villanueva\_He](https://forum.inductiveautomation.com/u/Carlos_Villanueva_He)\ **Post date:** [October 28, 2022, 10:06pm UTC](https://forum.inductiveautomation.com/t/transaction-groups-block-group-item-data-type-dataset/33143/7 "2022-10-28T22:06:41Z")
Will give that a try. I am using mysql as my database.