Skip to main content

Hello,

Is there a way to use a parameter from OPC-UA Extractor config.yml file in order to make a conversion of some numeric tags (i.e. conversion on the measurement unit from grams to pounds)? As I have not yet found any relatable parameter that would do this and using transformations as the data is pushed in CDF is not efficient on performance as I need to filter out the datapoints already converted.

Thanks,

Raluca

I've managed the conversions directly at the server side.


Hi Raluca, 

Are you aware that we introduced Unit support in CDF recently?  You can store your data points with a unit of grams, but specify the output of a query to be in pounds if you wish (conversions are calculated at query time and are not persisted).

This approach allows you to preserve the integrity of the original source data.

Here’s a link to the developer guide, if this is useful https://developer.cognite.com/dev/concepts/resource_types/units/


Thank you, @Glen Sykes , I'm aware of this, but we need to account for some decimal offsets too during conversion.

 


Ah ok.  I’m glad you were aware of the feature then at least. 

Just for reference, I believe you could accomplish the goal using a combination of a synthetic time series query with units and unit conversion.

https://developer.cognite.com/dev/concepts/resource_types/synthetic_timeseries.html

This would allow you to keep the data points in their original format in CDF and have a more visible audit trail as to how the data point values are what they are, within CDF.

Hope this is helpful? 

Best wishes from the CDF product team!

Glen
 



 


Thank you, @Glen Sykes , very helpful! Will look into it.

Regards,

Raluca


Hi @Raluca Bala,

We are following up to see whether you're satisfied with the responses you've received? 


Hi @Dilini Fernando ,

I've managed the conversions directly at the server side.

Thank you for your support.

 


Reply