Copy page

Transforms

Drop Key Where Value Equal

Drop a key from the record where the value is equal to a specified value.

Overview

Drop Key Where Value Equal removes a single key from a record when that key's value matches the configured value. The rest of the record is kept. If the value doesn't match, or the key isn't present, the record passes through unchanged.

To discard the whole record instead of a single key, use Drop Record Where Value Equal.

Configuration

Argument	Type	Required	Default	Description
key	string	true	—	The key to drop from the record
value	any	true	—	The value to drop to check for equality with the record's value

Example

Code
{
  "operation": "drop_key_where_value_eq",
  "arguments": {
    "key": "status",
    "value": "N/A"
  }
}

Given the input record:

Code
{
  "user": "jdoe",
  "status": "N/A",
  "action": "login"
}

The output record will be:

Code
{
  "user": "jdoe",
  "action": "login"
}

If the value does not match, given the input record:

Code
{
  "user": "jdoe",
  "status": "active",
  "action": "login"
}

The output record is unchanged:

Code
{
  "user": "jdoe",
  "status": "active",
  "action": "login"
}

Notes

1. The comparison is an exact match on both value and type: the string "10" does not match the number 10.
2. Use this operation with scalar values (strings, numbers, and booleans).