Contents x
      Standardize
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      Standardize

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

      General: [Standardize]

      COMING SOON














      {Description Here}

      Purpose

      Use this function to:
      • {}

      Return Value

      PropertyValue
      FieldTypeString  / Integer / Long(Integer) / Double / Date / DateTime
      FieldSizeLow / Med / High / Continuous
      DataTypeDiscrete / Continuous
      DataSizeShort / Integer / LongInteger / Double
      Example Return Value:

      {Insert Sample Here}


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

      		“p1”: “”

      		“p2”:Optional / Required. 
      Supports:  
      • DataType: 
      • Field Type: 
      • Fixed Value: 

      		“p3”:Optional / Required. 
      Supports:  
      • DataType: 
      • Field Type: 
      • Fixed Value: 
      Treat Null as Zero"nullIsZero": true
      "nullIsZero": false

      		True/False.
      Default = False
      If true, then any null values in the input fields will be treated as if they have a value of 0.

      JSON Sample

      {Insert JSON here}


      Usage Notes

      See Also:   

      • Engineering | Expression Field
      • {}

      Example

      ExampleDetails
      Description
      Input
      • Table: = [transactions]
      • Filter: = [No Filter]
      • Function: = 
      • {}:= {}
      • Name: =
      Sample




      Was this article helpful?
      What's Next