# Concat two datasets **URL:** \ **Category:** Ignition\ **Created:** [September 29, 2022, 1:56pm UTC](https://forum.inductiveautomation.com/t/concat-two-datasets/64653 "2022-09-29T13:56:49Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![justinedwards.jle](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/justinedwards.jle/32/37854_2.png) [@justinedwards.jle](https://forum.inductiveautomation.com/u/justinedwards.jle)\ **Post date:** [September 30, 2022, 3:56am UTC](https://forum.inductiveautomation.com/t/concat-two-datasets/64653/5 "2022-09-30T03:56:54Z")
@sebastien_ng Here is an example I created for somebody a little while back. It takes a dataset from a custom property, and a dataset from a tag and stitches them together into a data table using a common column. Once you get your head around the scripting, you probably won't too much trouble modifying this example to fit your usage case: > [@Added column shows in Designer but not in client](https://forum.inductiveautomation.com/t/added-column-shows-in-designer-but-not-in-client/63199/9): > > You could start with adding a custom dataset property to the power table. Call it originalData. Then bind that property to the SQL query to get the noteless data from the database. The query will have to include a primary key Then, you could create a dataset memory tag with two columns: “name of Primary Key” and “Notes” Afterwards, you would be able to create a custom method called “refreshTable” The code for the custom method would look like this: system.db.refresh(self,"originalData") da… --- _[View the full topic](https://forum.inductiveautomation.com/t/concat-two-datasets/64653)._