I have about 100 values in a dataset which I’d like to move into specific cells in an SQL database using a transaction group. When I try dragging and dropping a value from the dataset into transaction group it doesn’t work, it seems like I can only drag and drop the entire dataset.
I was going to create tags and reference each cell of the dataset, but I can’t seem to reach the individual cell values in the dataset to get that to work either.
Expression tags with this expression are erroring out: system.tag.read(“default]TagPath/Tablename”).value.getValueAt(0, 1)
Is there a better way to do this? I could try to set up a script to iterate through the dataset to return all the values and then write 100 lines of code to move them to the correct tags, and then move those 100 individual tags into the transaction group, but I assume there are better ways of doing this. Any tips are greatly appreciated.