Atomic Fields

Edit Field Template

Properties Dialog

The properties dialog (accessed by right-clicking a field in the Database Tree and selecting "Properties" displays the Atomic status of the field.  Imported fields will show {} as source JSON

 

Billing Report

Details of atomic fields are output when data is exported using the ExportCampaignDataSet method.   An output report is generated that lists the following:

• atomicExportFields[] - lists the atomic fields used in the generation of the fields in the export file.   Engineered fields will not be listed, but the atomic fields from which they were derived will be included.
• atomicDatasetFields[] - lists the atomic fields used in the query that selected the rows to be included in an export.   Engineered fields will not be listed, but the atomic fields from which they were derived will be listed.
• atomicFieldDetail[] - list the non-null count of atomic fields as listed in atomicExportFields[]   

Changing Atomic Field Status

In some cases it is necessary to treat engineered fields as if they were atomic fields.    This can be done using the SetAtomicFields API:

[
  {
    "method": "SetAtomicFields",
    "template": "sales_imported_to_atomic",
    "project": "SDJ-DJDemo2023",
    "description": "Set atomic fields using a template"
  },
  {
    "method": "SetAtomicFields",
    "table": "sales",
    "project": "SDJ-DJDemo2023",
    "description": "Set atomic fields for a whole table"
  },
  {
    "method": "SetAtomicFields",
    "fields": [
      "customer.first order",
      "customer.recency"
    ],
    "description": "Set atomic fields using a field list",
    "project": "SDJ-DJDemo2023"
  }
]