I am using Ignition Edge 8.0.10.
I import the dataset from .csv to a dataset tag. I then directly bind the dataset tag to a table on the window. I used below script on my client event script Tag Change and those value get updated each time the tag change. The above is working fine for me.
So right now, I would need to sum up all rows for Col3, Col4 and Col5 based on the type at Col2. I would need the total to be updated automatically each time when there is new row updated on the table. On my table, col2 is String and Col3,4,5 is double. Is this possible ? Any help is appreciated.
csvData = csv.reader(open(Path))
header = [“Col1”, “Col2”, “Col3”, “Col4”, “Col5”, “Col6”]
dataset = system.dataset.toDataSet(header,list(csvData))