Contents x
      FLogic Overview
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      FLogic Overview

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      FLogic Functions

      Functions that create flag fields denoting inclusion (1) or exclusion (0) from a set of records

      Purpose

      Use FLOGIC functions to:
      • Create boolean (True/False) fields, stored as 1 or 0
      • Evaluate Inclusion/Exclusion criteria
      • Evaluate equalities/inequalities
      • Create true/false sets

      Return Value

      PropertyValueNotes
      FieldTypeIntegerFLogic functions always return either 0, 1 or Null
      FieldSizeLowOnly 3 values are possible in an Flogic function
      DataTypeDiscrete Fields are always discrete
      DataSizeByteMost compact field type available


      Example Return Value: 
1, 0, null

      Data View

      Quick Profiler and Tree view


      Parameters

      ParameterJSONDescription
      Table“targetTable”: “MyTableName”The target table on which the new field will be created
      Filter“dataset”: {DataSet_JSON}Optional.   If a filter is applied, records not in the filter recordset will be returned as null.
      Function
      		"function":"flogic"

      Logic Function“p1”: “”Select the FLogic function from the drop-down list.
      Specifies the function to use.
      A - D
      		“p2-5”: “FieldName”
      “p2-5”: “#N*.N*”      		Fields to use for the values A-D.   Alternatively, a field can be replaced with a Fixed Value.  Fixed values must be preceded by the hash symbol (#).
      Supports:  
      • DataType: Discrete / Continuous
      • Field Type: All
      • Fixed Value:  #N*    e.g. #201596,    #-87  #mystringvalue   #N*.N*
      Name"name" : "FieldName"Required.   The name of the field to create.  

      JSON Sample


      Usage Notes

      Flag fields are processed and stored extremely efficiently by the DataJet engine, allowing for even more rapid analysis on very large tables.    They are stored as 1s and 0s.

      See Also:   



      Was this article helpful?
      What's Next