Name

summarizecolumns — Add the values from all columns that match the regular expression.

Syntax

summarizecolumns(regex)
              

The SUMMARIZECOLUMNS function has the following argument:

regex

The regular expression used to find matching columns.

Description

This function will sum all numeric columns whose column name matches a specified regular expression pattern.

Examples

Formula

Description

Result

summarizeColumns('feature\\.Yield\\..*')Sum the values of all columns whose names start with 'feature.Yield.': 
summarizeColumns('feature\\.Seral\\.(Mature|Old)\\.D')Sum the values of all columns whose names start with 'feature.Seral.', are 'Mature' or 'Old', and end with '.D'