FILTER_COLUMNS

Filter columns of data from a source table or JSON array.

Parameter List

Syntax
FILTER_COLUMNS(dataproperties
[header]
)
data

The JSON data or range from a source table to get the collumns from. The first row of data will be used as the header of the function. For example: A2 or A1:E4.

properties

Range or JSON array with the data properties (key values) the function will expose.

[optional] header

By default, the function returns the header (the first row of the range or the keys from JSON values). Use FALSE to remove it from the result or TRUE to get it.

Examples

FILTER_COLUMNS(A1:B3, '["Name","Age"]') returns [{"Name": "John", "Age": 20},{"Name": "Peter", "Age": 30}]