Copy page

Transformations

Lookup

Use this when you want to add extra information by matching values in your data against a reference table.

---

Lookup — DF_LOOKUP

Match values in one column against a reference table and add extra columns from that table.

Use this when: your data has a code or ID and you want to append readable names or additional properties — for example, device type names, location labels, or tariff bands.

Before

Code
[
  { "device_id": "AC-01", "kwh": 1.2 },
  { "device_id": "AC-02", "kwh": 1.7 },
  { "device_id": "AC-03", "kwh": 0.9 }
]

Lookup reference

Code
{
  "AC-01": { "name": "Meeting Room A", "floor": 1 },
  "AC-02": { "name": "Reception",      "floor": 1 },
  "AC-03": { "name": "Server Room",    "floor": 2 }
}

After

Code
[
  { "device_id": "AC-01", "kwh": 1.2, "name": "Meeting Room A", "floor": 1 },
  { "device_id": "AC-02", "kwh": 1.7, "name": "Reception",      "floor": 1 },
  { "device_id": "AC-03", "kwh": 0.9, "name": "Server Room",    "floor": 2 }
]

Code
{
  "type": "DF_LOOKUP",
  "config": {
    "lookupField": "device_id",
    "outputFields": ["name", "floor"],
    "lookupData": {
      "AC-01": { "name": "Meeting Room A", "floor": 1 },
      "AC-02": { "name": "Reception",      "floor": 1 },
      "AC-03": { "name": "Server Room",    "floor": 2 }
    }
  }
}

You can also reference a second query result as the lookup source using "lookupFrameIndex" instead of "lookupData".

---

Config from Query — DF_CONFIG_FROM_QUERY

Pull settings — like thresholds or limits — out of one query result and apply them as constants to your data.

Use this when: a configuration value lives in a separate query (for example, a per-device alert threshold stored in a settings table) and you want to attach it to every row.

Config query result

Code
[
  { "metric": "threshold", "value": 80 },
  { "metric": "minValue",  "value": 0 }
]

Main data — before

Code
[
  { "device": "AC-01", "kwh": 1.2 },
  { "device": "AC-02", "kwh": 1.7 }
]

After — the config values are mapped onto each row

Code
[
  { "device": "AC-01", "kwh": 1.2, "threshold": 80, "min": 0 },
  { "device": "AC-02", "kwh": 1.7, "threshold": 80, "min": 0 }
]

Code
{
  "type": "DF_CONFIG_FROM_QUERY",
  "config": {
    "configField": "metric",
    "valueField": "value",
    "outputMapping": { "threshold": "threshold", "min": "minValue" },
    "configFrameIndex": 1
  }
}

configFrameIndex points to the query that holds the config. outputMapping maps each output column to the config key it reads from.