Breaks the table into two at, or after the row matching the given condition, and returns either the top or bottom half.
TableBreak(Table or Table Name As Table, Column Index As Double, Condition As String, Top As Boolean, Include Break Row As Boolean)
Where:
Table or Table Name is the Table to break.
Column Index is the number of the column in which to check for a match.
Condition is the condition that defines the break.
Top will return the top portion of the break, when TRUE. Otherwise it will return the bottom portion when FALSE.
Include Break Row will include the row from which the break starts, when TRUE.
Rule | Meaning |
---|---|
TableBreak(DwLookupCustomers,1,"C*",TRUE,TRUE) | Will return an array of the rows from the Table Customers up to the entry beginning C, and will include the row at which the break occurs. |
Customers Table
CustomerName | City | Country |
---|---|---|
Amazon Warriors | Paris | France |
Bolton Burners | Concord | United States |
Boston Bulls | Hanover | Germany |
Cambridge Cats | Toulouse | France |
Dynamo Dynamics | Indiana | United States |
Eagle Sizzlers | Maine | United States |
Everso Lucky | Vermont | United States |
Forty Somethings | Illinois | United States |
CustomerName | City | Country |
---|---|---|
Amazon Warriors | Paris | France |
Bolton Burners | Concord | United States |
Boston Bulls | Hanover | Germany |
Cambridge Cats | Toulouse | France |
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","Concord","United States";"Boston Bulls","Hanover","Germany";"Cambridge Cats","Toulouse","France"} |