TableRemoveBlankRows (DriveWorks Documentation)

TableRemoveBlankRows

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

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.

Rule	Meaning
TableRemoveBlankRows(DWGroupTableCustomers)	Will remove only the rows where every cell is blank. See Example Outcome 1 below.
TableRemoveBlankRows(DWGroupTableCustomersBlankHeader, TRUE)	Will remove the rows and header where every cell is blank. See Example Outcome 2 below.
TableRemoveBlankRows(DWGroupTableCustomers, FALSE)	Will remove only the rows where every cell is blank. See Example Outcome 1 below.

DWGroupTableCustomers

DWGroupTableCustomersBlankHeader

For the rules:

TableRemoveBlankRows(DWGroupTableCustomers)

and

TableRemoveBlankRows(DWGroupTableCustomers, FALSE)

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

Table returned as an Array
{"CustomerName","City","Country";"Amazon Warriors","Paris","France";"Bolton Burners","","United States";"Cambridge Cats","Toulouse","France"}

For the rule:

TableRemoveBlankRows(DWGroupTableCustomersBlankHeader, TRUE)

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

Table returned as an Array
{"Amazon Warriors","Paris","France";"Bolton Burners","","United States";"Cambridge Cats","Toulouse","France"}