Filtering Rows and Columns

In many cases, data files or data sets contain rows or columns of information that you don't want. You can instruct Corda Server™ to filter out these rows and columns.

Note: Rows that have no data values are always ignored. The only exception to this is the first row of graph data, which can be used for category names.

Graphs

Filter rows and columns in graph data with the graph.enableRow and graph.enableColumn PCScript commands. These commands take two parameters:

• Enables (true) or disables (false) the specified row or column.

• Specifies the rows or columns to ignore.

For example, filter out columns 2,3, and 7 with a PCScript command similar to the following:

graph.enableColumn(false,2-3,7)

Important: Filtering works only for graphs that use the Standard data class. For more information, see Standard Data Class in the Corda® 7 Graph Guide.

For information about sending PCScript commands to Corda Server, see Using PCScript with Corda Embedder.

Maps

Specify the HTML table columns that include map data with the map.setMapDataColumns() command. This command takes two parameters:

• The column where Corda Server can find map shape names.

• The column where Corda Server can find data values.

For example:

AU.setMapDataColumns(2,3)

For information about sending PCScript commands to Corda Server, see Using PCScript with Corda Embedder.