Alteryx Trifacta Classic Experience Wrangle Language Other Functions Other Functions These additional functions provide a variety of useful capabilities for wrangling your data. COALESCE Function RAND Function RANDBETWEEN Function PI Function SOURCEROWNUMBER Function IF Function CASE Function Ternary Operators IPTOINT Function IPFROMINT Function RANGE Function HOST Function DOMAIN Function SUBDOMAIN Function SUFFIX Function URLPARAMS Function