Send feedback Cloud Dataprep by Trifacta Documentation Documentation Other Functions These additional functions provide a variety of useful capabilities for wrangling your data. Topics: COALESCE Function RAND Function SOURCEROWNUMBER Function IF Function Ternary Operators IPTOINT Function IPFROMINT Function RANGE Function DOMAIN Function SUBDOMAIN Function SUFFIX Function CASE Function RANDBETWEEN Function PI Function HOST Function URLPARAMS Function Was this page helpful? Let us know how we did: Send feedback Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 3.0 License, and code samples are licensed under the Apache 2.0 License. For details, see our Site Policies. Java is a registered trademark of Oracle and/or its affiliates. Last updated July 18, 2018.