Skip to main content

Cleanse (AX)

Synopsis​

This operator attempts to provide the same functionality as the Data Cleansing tool in Alteryx.

Description​

This operator attempts to provide the same functionality as the Data Cleansing 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​

example set input​

An ExampleSet

Output​

example set output​

An ExampleSet

Parameters​

Remove null rows​

Removes null rows.

Remove null columns​

Removes null columns.

Attribute list​

The attributes to be cleansed. If there is more than one attribute then the list must be comma separated. It is acceptable to have either no symbol or just double quotation marks around each attribute name.

Replace null blanks​

Replaces null blanks.

Replace null zeros​

Replaces null zeros.

Remove leading trailing whitespace​

Removes leading and trailing whitespace.

Remove tabs lbs dup whitespace​

Removes tabs, line breaks, and duplicate whitespace.

Remove all whitespace​

Removes all whitespace.

Remove letters​

Removes letters.

Remove numbers​

Removes numbers.

Remove punctuation​

Removes punctuation.

Modify case​

Modifies the case of all letters.

Case​

The resulting case after modification.