Astera Data Stack
⌘Ctrlk
Astera Data Stack
  • Welcome to Astera Data Stack Documentation
    • Upgrading from Astera 5.1 to 6.0
    • Introduction to Astera 6 Webinar Video
    • Introducing Dataflows
    • Dataflow Examples
    • Parameterizing Dataflows
    • Sources
    • Transformations
    • Destinations
    • Maps
    • Data Logging and Profiling
    • Database Write Strategies
    • Adding Workflow Tasks
    • Creating Workflows
    • Customizing Workflows With Parameters
    • Using Workflow Designer
    • Using Subflows in Astera
    • Report Model Tutorial
    • Applying an Existing Model to a New Report
    • Using Report Models to Extract Business Information from Printed Documents
    • Introducing Function Transformations
    • Functions Glossary
    • Custom Functions
    • Logical
      • Coalesce (Any value1, Any value2)
      • IsNotNull (AnyValue)
      • IsRealNumber (AnyValue)
      • IsValidSqlDate (Date)
      • IsDate (AnyValue)
      • If (Boolean)
      • If (DateTime)
      • If (Double)
      • Exists
      • If (Int64)
      • If (String)
      • IsDate (str, strformat)
      • IsInteger (AnyValue)
      • IsNullOrWhitespace (StringValue)
      • IsNullorEmpty (StringValue)
      • IsNull (AnyValue)
      • IsNumeric (AnyValue)
    • Conversion
    • Math
    • Financial
    • String
    • Date Time
    • Files
    • Date Time With Offset
    • GUID
    • Encoding
    • Regular Expressions
    • TimeSpan
    • Matching
    • Job Scheduling
    • Astera API User Guide
    • Astera Best Practices Dataflows
    • Astera Options
    • Astera Webinar Series
    • MySQL date/time conversion error
    • Report Model Monthly Online Training
    • Server Command Line Utility
    • Shared Actions
    • Shared Connections
    • Working with Data Formats
    • Using the Data Source Browser
    • Using the Query Editor
Powered by GitBook
For the complete documentation index, see llms.txt. This page is also available as Markdown.
  1. Version 6
  2. Functions

Logical

Coalesce (Any value1, Any value2)IsNotNull (AnyValue)IsRealNumber (AnyValue)IsValidSqlDate (Date)IsDate (AnyValue)If (Boolean)If (DateTime)If (Double)ExistsIf (Int64)If (String)IsDate (str, strformat)IsInteger (AnyValue)IsNullOrWhitespace (StringValue)IsNullorEmpty (StringValue)IsNull (AnyValue)IsNumeric (AnyValue)
PreviousCustom FunctionsNextCoalesce (Any value1, Any value2)

© Copyright 2026, Astera Software