A eq B

  • 1 minute(s) read
Prev Next

FLogic: A=B

Returns 1 if [A=B], 0 if [A<>B] and Null for all excluded records

Purpose

Use this function to:
  • Identify matching records
  • Flag records which meet specified criteria
  • Flag records where the statement A=B is true

Return Value

PropertyValue
FieldTypeInteger
FieldSizeLow
DataTypeDiscrete 
DataSizeByte


Example Return Value: 0, 1, null


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”FLogic
Logic Function
"p1":"A=B"
A=B
A“p2”: “FieldName”
“p2”: “#N*.N*”
“p2”: “#N*”
“p2”: “#MyString”
“p2”: “#YYYY-MM-DD”		Required. Field or value to compare with value B
Supports:  
  • DataType: Discrete / Continuous
  • Field Type: Any
  • Fixed Value:  #N*    e.g. #201596,    #-87
  • Fixed Value: #N*.N* e.g. #201596.05,    #-87.98
  • Fixed Value: #MyStringValue  e.g. #Product1    #-This is also a valid string  
  • Fixed Value:  #YYYY-DD-MM    e.g. #2021-12-06

B“p2”: “FieldName”
“p2”: “#N*.N*”
“p2”: “#N*”
“p2”: “#MyString”
“p2”: “#YYYY-MM-DD”		Required. Field or value to compare with value A
Supports:  
  • DataType: Discrete / Continuous
  • Field Type: Any
  • Fixed Value:  #N*    e.g. #201596,    #-87
  • Fixed Value: #N*.N* e.g. #201596.05,    #-87.98
  • Fixed Value: #MyStringValue  e.g. #Product1    #-This is also a valid string
  • Fixed Value:  #YYYY-DD-MM    e.g. #2021-12-06

Special test cases
  • To test for null, use #null
  • To test for an empty string, use #

JSON Sample


Usage Notes

See Also:   

  • Engineering | Expression Field
  • Hotbar >> Right-click | Save | Save As Field
  • A!=B, A>B...  (FLogic Functions)

Example

ExampleDetails
DescriptionFlag customers who work freelance
Input
  • Table: = [customer]
  • Filter: = [No Filter]
  • Function: = FLogic
  • Logic Function = A=B
  • A:= [customer ].[Occupation]
  • B:= #freelance
  • Name: = IsFreelance
Sample