SCAN (PQL - xl)

This function scans an array by applying a LAMBDA to each value and returns an array that has each intermediate value

  • Library: PQL \ Spreadsheet \ Logical
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

SCAN(OPTIONAL initial value, array, function)

Function Arguments

Name

Description

Type

Optional

initial value

Sets the starting value for the accumulator

StringOrNumber

Y

array

An array to be scanned

StringOrNumber

function

A LAMBDA that is called to scan the array

String

Comments

This function is the same as the Microsoft Excel 'SCAN' function - using the same inputs, logic and outputs.