📄️ CONCAT
Combine multiple strings and columns into single strings using Coalesce CONCAT function. Learn syntax, parameter handling, NULL behavior, and helper token integration for creating formatted text fields and complex string expressions in data transformations.
📄️ 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 the RANK function in Coalesce for assigning integer ranks within data partitions. Understand windowing syntax, tie behavior, dense ranking alternatives, and helper token integration for advanced data transformation and analytics workflows.
📄️ REPLACE
Clean and standardize data using Coalesce REPLACE function to remove prefixes, standardize delimiters, and format text fields. Learn search and replacement patterns with helper tokens for consistent data transformation across pipelines.
📄️ SUBSTR
Extract substrings from text data using Coalesce SUBSTR function with positive and negative indexing. Learn position-based string extraction, optional length parameters, and helper token integration for precise text manipulation in data transformations.
📄️ TO_DATE
Convert string expressions to dates in Coalesce using TO_DATE function across Snowflake and Databricks platforms. Learn format strings, error handling with TRY_TO_DATE, ANSI mode considerations, and helper token integration for reliable date transformations.
📄️ TRIM Functions
Clean string data using Coalesce TRIM, LTRIM, and RTRIM functions to remove whitespace and specified characters. Learn syntax variations, character removal patterns, and helper token integration for comprehensive data cleaning workflows.
📄️ Using Math in Transformations
Perform mathematical calculations in Coalesce SQL transformations using addition, subtraction, multiplication, and division operations. Learn data type rules, precision control with ROUND and CAST functions, and helper token integration for numeric data processing.