Enable conditional substitution between fields in a Data View
As a Data Scientist exploring or analyzing my dataset, I want to have the ability to configure a Data View to conditionally substitute the value from one field into another field (for instance if a field has a null value at one interval, fill that interval with the value from a different field)
An example of a common use case would be regarding PI tags sent to OCS via the PI to OCS Agent. Consider a scenario where a numeric PI tag (eg. of type Float) had a period where it stored system Digital State values (eg. Bad Input) instead of its normal, expected numeric values (potentially caused by some sort of outage or issue at the data source).
When transferred via the PI to OCS Agent, this OCS Stream would have a property "Value" that would return null values during this outage period, and another property "DigitalStateName" that would store this context behind it, such as "Bad Input" or "No Data".
By conditionally substituting the values of "DigitalStateName" into the "Value" field, in this example, you could achieve a set of data that is akin to what the PI System would serve it to you - a single column of data, showing "Values" where they exist, but the value of "DigitalStateName" where those values were not present.
(Due to the expanded nature of OCS Streams vs PI Tags, a solution must take into account use cases and needs beyond this specific example)