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

Turn text to number during OData data ingestion

335 Views

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 (https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/eac3111c11174776856d9c1fb56f7679.html), 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?