Page tree

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Code Block
{"q":["hello", "world"]}

Column reference example:



derive type:single value:FILTEROBJECT(myObjects, '[k1,k2]') as:'k-values'

Output: Generates a new k-values column containing an Object of key-value pairs for all instances of the k1 and k2 keys.


D code

derive type:single value:FILTEROBJECT(obj,'keys')


ArgumentRequired?Data TypeDescription
objYString or ObjectFunction returning an Object or Object literal to be filtered
keysYArrayArray representing the keys to filter. Each element can be a String, function returning a String, or a reference to a column of String values.