Remove columns and rows with Nulls

[rsivasankaran]

Need a tool that can remove nulls in 2 ways:

1. Remove rows with null values

2. Remove columns with null values

[cgoodman]

This functionality exists in the data cleanse tool. I can’t remember when it was added but sometime post around 2020.4.

[rsivasankaran]

I can't get this to work using the Data Cleansing Tool. It does not remove the rows with NULL values in any of the columns. See picture for details.

[cgoodman]

It is designed to only remove rows where all fields have a null value or all columns where every record is null.