Built-in Functions → getColumn

The getColumn(string exp1,..., string expN) function is available starting with the 2025.7 release. This function constructs a fully qualified column name by concatenating multiple string parameters. Each parameter is case-sensitive and represents part of the column name. It returns the value of the specified column.

Note

The getColumn function cannot be used in physical schema formulas, load filters, or security filters.

Key Benefits:

The getColumn allows you to create more dynamic and reusable dashboards by selecting columns at runtime based on global variables, presentation variables, or text values. Instead of hardcoding specific schema, table, or column names, you can use this function to adjust insights automatically based on your selections or filters.

  • Dynamic Dashboards: Eliminates the need to hardcode schema, table, or column names—drive insights using runtime parameters
  • Simplified Maintenance: Reduces the overhead of managing duplicate dashboards or reports for each schema variation

About this function:

  • Accepts global variables, presentation variables, and literals, all of which must be of string data type. Session variables** are not supported.
  • Can be used inside business views, insights, and dashboards
  • When used inside a Business View, it will mark the business view as unverified.
  • If the resolved column name is invalid, the result will display #Error.

Signature

getColumn(string exp1, string exp2,, string expN)

The string expression can be a global variable, presentation variable, or string literal.

Example

Return the value of the SOLD_AMOUNT column from the SALES table, where the specific schema is determined by the value of the global variable gv1:

getColumn($gv1, "SALES.", "SOLD_AMOUNT")