DriveWorks Solo 23

TableRemoveBlankColumns

TableRemoveBlankColumns

Removes any columns from the table where every cell in that column is blank.

Syntax

TableRemoveBlankColumns(Table, Include Header Row)

Where:

Table is the Table to remove blank rows from.

Include Header Row (optional) is True if the header row should be considered when deciding if a column is blank. False or omitted will not consider the header row.

Examples

Example Data

DWGroupTableCustomers

Example Outcome 1

For the rules:

TableRemoveBlankColumns(DWGroupTableCustomers)

and

TableRemoveBlankColumns(DWGroupTableCustomers, FALSE)

DriveWorks will return the table above as an array, which will look like:

Example Outcome 2

For the rule:

TableRemoveBlankColumns(DWGroupTableCustomers, TRUE)

DriveWorks will return the table above as an array, which will look like: