Merging columns by sum

[daniel4]

This is kind of a dumb problem. Because I could have solved it by a little bit of thinking in the beginning. I have a bunch of power meters that I need the combined energy readings from and show it in a table. I have all the readings saved in the historian. But didn't think to make a tag for the combined value. So my question is. Is there a way that I can get the data and add it up after the fact. (timestamps should be the same so that's not a problem).
I know I could probably write a script that could do this. But if there is some tagHistory binding or expression magic that I'm not aware of that would be great.

Example:

[Transistor]

Are the Dataset1 and Dataset2 t_stamps exactly as shown or are there fractions of a second in the actual values in the database?

[daniel4]

This is how it looks in the designer

[daniel4]

There is functionality that is soooo close but not quite. The sum function just needs one more overload for merge and we are golden

I will just try my hand at a script until someone finds a better way.

[PGriffith]

Not possible with vanilla expressions, but I bet Phil's (free) integration toolkit could do it:

Automation Professionals' Integration Toolkit Module

Automation Professionals is pleased to announce the immediately availability of a major upgrade to its free Simulation Aids Integration Toolkit module. The new feature justifying the "major upgrade" language is the implementation of eleven thirty-one new expression functions which use iteration to accomplish complex transforms of datasets and lists, to or from other datasets and lists, applying filtering, ordering, and computed new columns along the way. While there are certain operations that…

[pascal.fragnoud]

@daniel4

But didn't think to make a tag for the combined value

Make it now ! Otherwise, future you will blame present you for working around the issue instead of fixing it !

[daniel4]

Yeah it was the first thing I did after noticing my blunder