DriveWorks Pro 24

TableFilterByRowFunction

TableFilterByRowFunction

Filters a table of data or array using the provided Lambda Function applied to each row.

Syntax

TableFilterByRowFunction(Input Array, Filter Function, [Include Header Row])

Where:

Input Array is the array to iterate over.

Filter Function if the result of this function is TRUE, it will be included in the result.

Include Header Row (optional) if true, the header will be included in the filter.

• Input Arrays are assumed to include a header row by default. Set this argument to TRUE if the Input Array does not have a header row.

Filter Function

Please see Higher Order Functions for more information on this type of function.

The DWLambda used for the filter function uses the following syntax:

DWLambda(dataRow, [rowIndex], Function)

dataRow is the row from the Input Array to be evaluated.

• When the Input Array is parsed each dataRow is passed to the function.
• dataRow is a required parameter in the Function Argument.

rowIndex (optional) is the index of the row currently being evaluated.

• When the Input Array is parsed the index of each row is passed to the function.
• Using the dataRow in the Function argument is optional.
• The Filter Function will not retrieve values from the header row. A rowIndex of 1 will refer to the first data row, which is the first row after the header row or the first row in a table with no headers (in which case Include Header Row must be set to TRUE).

Function is the Lambda function to be executed.

• Each row in the Input Array where this function equals True will be included in the result.
• We recommend only using pure functions in the filter.
• Also observe the information on Blocked Functions and Further Restrictions.

Examples

TableFilterByRowFunction(
	DwLookupBeamSizesSy, 
		DWLambda(
			dataRow, 
			TableGetValue(dataRow,3,1)*100<TableGetValue(dataRow,2,1)
		)
	,FALSE
)

TableFilterByRowFunction(
	DwLookupBeamSizesSy, 
	DWLambda(
		dataRow, 
		rowIndex, 
		If(
			rowIndex=11,
			TRUE, 
			TableGetValue(dataRow,3,1)*100<TableGetValue(dataRow,2,1)
			)
		),FALSE
	)

See Also

Higher Order Functions - About higher order functions.

DWLambda - Allows custom, reusable functions to be created.

TableMap - Applies a Lambda Function across a provided array and returns a new array with the result of the Lambda function applied.

TableFilterByFunction - Filters an array based on a single column using the provided Lambda Function.