Dataprep by TrifactaTrifacta ApplicationWrangle LanguageOther FunctionsOther FunctionsThese additional functions provide a variety of useful capabilities for wrangling your data.COALESCE FunctionRAND FunctionRANDBETWEEN FunctionPI FunctionSOURCEROWNUMBER FunctionIF FunctionCASE FunctionTernary OperatorsIPTOINT FunctionIPFROMINT FunctionRANGE FunctionHOST FunctionDOMAIN FunctionSUBDOMAIN FunctionSUFFIX FunctionURLPARAMS Function