Page Comparison

...

You have a calculate stream processing, say, 10,000 records - and you want to accumulate totals based on a key value, of which there are 100 across the data set. For each key value, many records will be added to the total. To do this, you should use an a call to the cache function such as:

...
cache ( _out.KeyVal,
    if (_cacheValue == _NULL,
		$currentValue = 0
	, // else
		$currentValue = _cacheValue
	),
	$currentValue = $currentValue + _out.CashValue,
	$currentValue
)
...

...

...
$currentValue = cache(_out.KeyVal),
if ($currentValue == _NULL,
	cache(_out.KeyVal, _out.CashValue)
, // else
	cache(_out.KeyVal, $currentValue + _out.CashValue)
),
...

Syntax

cache(cache key, expression1, expression2, [,..., expressionN])

...