Expose Values with Duplicate Timestamps in Transpose Function
In the current implementation of the transpose archive in OLEDBEnt, a user is unable to retrieve data that may exist at the same timestamp as another piece of data. This is because the time column is treated as the primary key of the transpose table. I would like to be able to retrieve all data using the archive transpose function regardless if timestamps are duplicated.
Carlos Sola, AGSolution commented
As an example, in our case, we cannot make use of this Transpose Function for retrieving serveral alarm attributes in different columns.
The function only takes values from the first timestamp duplicated.