DriveWorks Solo 23

TableRemoveBlankRows

TableRemoveBlankRows

Removes any rows from the table where every cell in that row is blank.

Syntax

TableRemoveBlankRows(Table, Remove Blank Header)

Where:

Table is the Table to remove blank rows from.

Remove Blank Header (optional) is False, or omitted, to keep header row even if it is blank.

Examples

Example Data

DWGroupTableCustomers

DWGroupTableCustomersBlankHeader

Example Outcome 1

For the rules:

TableRemoveBlankRows(DWGroupTableCustomers)

and

TableRemoveBlankRows(DWGroupTableCustomers, FALSE)

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

Example Outcome 2

For the rule:

TableRemoveBlankRows(DWGroupTableCustomersBlankHeader, TRUE)

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