Skip to main content

Multi-Row Formula (AX)

Synopsis

This operator attempts to provide the same functionality as the Multi-Row Formula tool in Alteryx.

Description

This operator attempts to provide the same functionality as the Multi-Row Formula tool in Alteryx. .


**This code is the proprietary and confidential information of Altair Engineering Inc. All use of this code is subject to the terms of Altair's non-disclosure agreement and partnership agreement. The code is strictly prohibited from distribution without prior written permission by Altair. **


Input

input 1

An input port

Output

result 1

A result port

Parameters

Num rows

The number of rows (lag) to be used (e.g. -1 or 1)

Update attribute

Whether or not to update an existing attribute

Update attribute name

The name of the updated attribute.

Create attribute name

The name of the newly-created attribute (only used if update_attribute is set to False)

Expression

The expression (formula) to be applied