Copy page

Transformations

Picking and Shaping Fields

Use these when you want to control which columns appear in your data — hide system fields, rename labels, or reorder columns.

---

Select Fields — DF_SELECT_FIELDS

Keep only the columns you need, or remove specific ones you don't want.

Use this when: your data has many columns but you only want to show a few, or you need to hide internal fields like _id before displaying a table.

Before

Code
[
  { "timestamp": "08:00", "device_id": "AC-01", "kwh": 1.2, "_id": "abc", "__v": 0 },
  { "timestamp": "09:00", "device_id": "AC-01", "kwh": 1.4, "_id": "def", "__v": 0 },
  { "timestamp": "10:00", "device_id": "AC-01", "kwh": 1.1, "_id": "ghi", "__v": 0 }
]

After — keeping only timestamp, device_id, and kwh

Code
[
  { "timestamp": "08:00", "device_id": "AC-01", "kwh": 1.2 },
  { "timestamp": "09:00", "device_id": "AC-01", "kwh": 1.4 },
  { "timestamp": "10:00", "device_id": "AC-01", "kwh": 1.1 }
]

Code
{
  "type": "DF_SELECT_FIELDS",
  "config": {
    "mode": "include",
    "fieldNames": ["timestamp", "device_id", "kwh"]
  }
}

Set mode to "exclude" to remove specific columns instead.

---

Rename Fields — DF_RENAME_FIELDS

Change the name of one or more columns.

Use this when: column names from your data source use shorthand or internal naming, and you want friendlier labels in your charts and tables.

Before

Code
[
  { "ts": "08:00", "dev": "AC-01", "kwh": 1.2 },
  { "ts": "09:00", "dev": "AC-01", "kwh": 1.4 },
  { "ts": "10:00", "dev": "AC-01", "kwh": 1.1 }
]

After — renaming ts → Time, dev → Device, kwh → Energy (kWh)

Code
[
  { "Time": "08:00", "Device": "AC-01", "Energy (kWh)": 1.2 },
  { "Time": "09:00", "Device": "AC-01", "Energy (kWh)": 1.4 },
  { "Time": "10:00", "Device": "AC-01", "Energy (kWh)": 1.1 }
]

Code
{
  "type": "DF_RENAME_FIELDS",
  "config": {
    "renameMap": {
      "ts": "Time",
      "dev": "Device",
      "kwh": "Energy (kWh)"
    }
  }
}

---

Organise Fields — DF_ORGANIZE_FIELDS

Reorder, rename, and hide columns all in one step.

Use this when: you want to do a final cleanup before a table panel — put the most important columns first, rename a few, and drop the rest.

Before

Code
[
  { "_id": "abc", "kwh": 1.2, "device_id": "AC-01", "timestamp": "08:00", "__v": 0 },
  { "_id": "def", "kwh": 1.4, "device_id": "AC-01", "timestamp": "09:00", "__v": 0 }
]

After — reordered, renamed, and internal fields hidden

Code
[
  { "Time": "08:00", "Device": "AC-01", "Energy (kWh)": 1.2 },
  { "Time": "09:00", "Device": "AC-01", "Energy (kWh)": 1.4 }
]

Code
{
  "type": "DF_ORGANIZE_FIELDS",
  "config": {
    "order": ["timestamp", "device_id", "kwh"],
    "renameMap": {
      "timestamp": "Time",
      "device_id": "Device",
      "kwh": "Energy (kWh)"
    },
    "hideFields": ["_id", "__v"]
  }
}

---

Filter Fields by Name — DF_FILTER_FIELDS_BY_NAME

Keep or remove columns whose names match a pattern (using a text pattern).

Use this when: you have many columns that follow a naming convention and you want to bulk-include or bulk-remove them — for example, keep all columns that start with sensor_, or remove everything that starts with _.

Before

Code
[
  { "timestamp": "08:00", "sensor_temp": 24.1, "sensor_humidity": 60, "sensor_co2": 412, "_id": "abc", "__v": 0 }
]

After — keeping only columns that start with sensor_

Code
[
  { "sensor_temp": 24.1, "sensor_humidity": 60, "sensor_co2": 412 }
]

Code
{
  "type": "DF_FILTER_FIELDS_BY_NAME",
  "config": {
    "mode": "include",
    "pattern": "^sensor_"
  }
}