Home Search

DriveWorks Pro 22
TableRemoveBlankRows

Send Feedback

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

RuleMeaning
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.

Example Data

DWGroupTableCustomers

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton Burners[Blank]United States
[Blank][Blank][Blank]
Cambridge CatsToulouseFrance

DWGroupTableCustomersBlankHeader

[Blank][Blank][Blank]
Amazon WarriorsParisFrance
Bolton Burners[Blank]United States
[Blank][Blank][Blank]
Cambridge CatsToulouseFrance

Example Outcome 1

For the rules:

TableRemoveBlankRows(DWGroupTableCustomers)

and

TableRemoveBlankRows(DWGroupTableCustomers, FALSE)

CustomerNameCityCountry
Amazon WarriorsParisFrance
Bolton Burners[Blank]United States
Cambridge CatsToulouseFrance

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"}

Example Outcome 2

For the rule:

TableRemoveBlankRows(DWGroupTableCustomersBlankHeader, TRUE)

Amazon WarriorsParisFrance
Bolton Burners[Blank]United States
Cambridge CatsToulouseFrance

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"}