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
obj_colYString or ObjectName of column, function Function 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.

D s lang notes


Object literal , name of the Object column, or function returning an Object whose keys you want to extract into an array.