📄️ CONCAT
Learn how to combine multiple strings, columns, or expressions into a single string using the CONCAT function in Coalesce. Perfect for creating formatted text fields, combining names, or building complex string expressions.
📄️ Using Conditionals in Coalesce
Learn how to implement if-else logic in Coalesce using CASE statements, IF/IFF functions, and conditional SQL. This comprehensive guide covers conditional transformations for both Snowflake and Databricks, including DECODE, Post-SQL updates, helper token usage, and best practices for choosing between different conditional approaches. Complete with practical examples and platform-specific syntax.
📄️ RANK
Learn how to use the RANK function in Coalesce to assign ranks to rows within partitions of your dataset. This guide covers syntax, tie behavior, windowing, and practical usage with Helper Tokens.
📄️ REPLACE
Learn how to the REPLACE function in Coalesce to standardize data formats, remove unwanted prefixes, and clean text fields.
📄️ SUBSTR
Learn how to use the SUBSTR function in Coalesce to extract substrings from text data. This guide covers position-based string extraction, both positive and negative indexing, optional length parameters, and practical examples using Helper Tokens.
📄️ TO_DATE
Learn how to use the TO_DATE function in Coalesce to convert string expressions into date values. This guide covers platform-specific syntax, format string usage, and practical examples using Helper Tokens.
📄️ TRIM Functions
Coalesce's comprehensive guide to LTRIM, RTRIM, and TRIM for cleaning string data, with syntax, examples, and best practices.
📄️ Using Math in Transformations
Learn how to use basic mathematical operations in SQL transformations to calculate derived values from numeric columns.