Can I create a function ( UDF ) in Incorta? ( use case: csv files show percents, I need to convert to decimal - a *lot* ;-) )
The title sums it up - I have a need to take a text input ( e.g. 16.7% ) and conditionally format the output ( e.g. > 15% green, > 10 yellow, etc. ) Since the comparison operator wants a number I need to convert the text to a decimal. Doing it isn't difficult, but I'd like to make it a standard and easily repeatable operation since we will have a lot of columns coming in this way.
Hello Dawson Sr,
I have come across the same scenario and below are the points which you can consider in your case.
1. if you have write access privileges , you can create a new aggregate column (e.g. > 15% green, > 10 yellow, etc. ) by using trim/substring Mysql functions.
2. if your table is already in incorta environment, you can make a MV on top of this table ( C.T.E is best way) and extract the column by using Incorta supported functions
below point worked for me -
3. Make a program/script which should run daily/hourly as per your requirement and place raw files in google drive so your program read and do modification and write back in google drive folder and that folder you can use as data source in incorta .
if you get inbuilt incorta functionality that's great as I'm not aware of it. Incorta support team would let you know about it.
let me know if you have any question.