Concat two datasets

[justinedwards.jle]

@Sebastiao_Nankuta_Ga
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

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…