Common Transformations

Learn how to leverage essential SQL transformations in Coalesce for data manipulation. This comprehensive guide covers common string and data manipulation functions with detailed syntax, examples, and best practices for integrating these transformations into your data pipelines.

📄️ 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.

📄️ TRIM Functions

Coalesce's comprehensive guide to LTRIM, RTRIM, and TRIM for cleaning string data, with syntax, examples, and best practices.

📄️ 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.

📄️ 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.

📄️ Using Math in Transformations

Learn how to use basic mathematical operations in SQL transformations to calculate derived values from numeric columns.