Data Quality - Issue with functions in the data rule logic
Posted: Tue Jan 03, 2017 9:56 am
Hello,
I am working on a data rule logic in the Information Analyzer to pull the remainder from a decimal value.
I tried functions like Mod,FLOOR, Ceil but it's throwing errors saying they are not known scalar functions. I also tried using right function, this one worked but I can not bind the variable as it's converting the type to string based on the string function I used.
column_name_FLOOR(column_name)
right(column_name,2)
I went through the below forum chain and tried using Val() function but still I am having the binding issue.
http://dsxchange.com/viewtopic.php?t=156215
val(right(column_name,2))
can someone please help me fix this. TIA.
I am working on a data rule logic in the Information Analyzer to pull the remainder from a decimal value.
I tried functions like Mod,FLOOR, Ceil but it's throwing errors saying they are not known scalar functions. I also tried using right function, this one worked but I can not bind the variable as it's converting the type to string based on the string function I used.
column_name_FLOOR(column_name)
right(column_name,2)
I went through the below forum chain and tried using Val() function but still I am having the binding issue.
http://dsxchange.com/viewtopic.php?t=156215
val(right(column_name,2))
can someone please help me fix this. TIA.