---
title: "FLogic Overview"
slug: "flogic-overview"
updated: 2021-12-16T09:17:11Z
published: 2021-12-16T09:17:11Z
canonical: "docs.datajet.app/flogic-overview"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# FLogic Overview

## 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

| Property | Value | Notes |
| --- | --- | --- |
| **FieldType** | Integer | FLogic functions always return either 0, 1 or Null |
| **FieldSize** | Low | Only 3 values are possible in an Flogic function |
| **DataType** | Discrete | Fields are always discrete |
| **DataSize** | Byte | Most compact field type available |

```shell
Example Return Value: 
1, 0, null
```

### Data View

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/FLog_Overview_DataView.PNG)

### Quick Profiler and Tree view

### ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/FLOG_Overview_QuickProfiler.PNG)

## Parameters

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/FLog_Overview_Parameters.PNG)

| Parameter | JSON | Description |
| --- | --- | --- |
| **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

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/Flog_Overview_JSON.PNG)

## 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:

- [Field and Table Names](/v1/docs/generaltemplate)
- Engineering | Expression Field

##