Astera Data Stack
search
⌘Ctrlk
Astera Data Stack
  • Welcome to Astera Data Stack Documentation
  • Release Notes
    • Upgrading from Astera 5.1 to 6.0
  • Getting Started
    • Introduction to Astera 6 Webinar Video
  • Dataflows
    • Introducing Dataflows
    • Dataflow Examples
    • Parameterizing Dataflows
    • Sources
    • Transformations
    • Destinations
    • Maps
    • Data Logging and Profiling
    • Database Write Strategies
  • Workflows
    • Adding Workflow Tasks
    • Creating Workflows
    • Customizing Workflows With Parameters
    • Using Workflow Designer
  • Subflows
    • Using Subflows in Astera
  • Report Model
    • Report Model Tutorial
    • Applying an Existing Model to a New Report
    • Using Report Models to Extract Business Information from Printed Documents
  • Functions
    • 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
  • Integration Server
    • Job Scheduling
  • Miscellaneous
    • 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
gitbookPowered by GitBook
block-quoteOn this pagechevron-down
  1. Functions

Logical

Coalesce (Any value1, Any value2)chevron-rightIsNotNull (AnyValue)chevron-rightIsRealNumber (AnyValue)chevron-rightIsValidSqlDate (Date)chevron-rightIsDate (AnyValue)chevron-rightIf (Boolean)chevron-rightIf (DateTime)chevron-rightIf (Double)chevron-rightExistschevron-rightIf (Int64)chevron-rightIf (String)chevron-rightIsDate (str, strformat)chevron-rightIsInteger (AnyValue)chevron-rightIsNullOrWhitespace (StringValue)chevron-rightIsNullorEmpty (StringValue)chevron-rightIsNull (AnyValue)chevron-rightIsNumeric (AnyValue)chevron-right
PreviousCustom Functionschevron-leftNextCoalesce (Any value1, Any value2)chevron-right

© Copyright 2025, Astera Software