Generates a standard for a string using a standardization definition in the QKB.
Category: | Data Quality |
Returned data type: | Integer |
Note: | The returned value is a Boolean value where 1= success and 0 = error. |
DQ.STANDARDIZE(stand_def, input, result)
stand_def
a string representing the name of a standardization definition in the QKB
input
a string representing the input value or input field name
result
a string representing the output field name
The DQ.STANDARDIZE function generates a normalized standard for an input string and outputs the standard to a field.
The function is a member of the data quality class. A data quality object can be declared as a variable and must then be initialized through a call to the function DQ_INITIALIZE. The member function DQ.LOADQKB must then be called to load the contents of a QKB into memory and link that QKB with the data quality object. The data quality object then retains information about the QKB and the QKB locale setting.
When calling DQ.STANDARDIZE, you must specify the name of a standardization definition. A standardization definition is an object in the QKB that contains context-specific reference data and logic used to generate a standard for the input string. Refer to your QKB documentation for information about which standardization definitions are available in your QKB.
dq dataq
string output
dataq = dq_initialize()
dataq.loadqkb("ENUSA")
dataq.standardize("Name", "mcdonald, mister ronald", output)
// Outputs "Mr Ronald McDonald"