Skip to Content
Oct 23, 2019 at 06:41 PM

Turn text to number during OData data ingestion


I have an OData data source. It has an attribute which is formatted as text (and for some reason that cannot be changed), and it contains numbers (formatted as text). I know that there is a ToNumber function in SAC (, but as I (novice SAC user) understand this can only be used in a story. I want to ideally perform this during the OData data ingestion, as the data is refreshed, copying the text data into a new SAC attribute which is formatted as a measure, being filled with numbers converted from the text data.

Any idea?