Data Cleanse "Remove Null Rows" not working

[Bobbins]

Hello,

This data originates from a PDF import in the intelligence suite, although I have changed the data itself for obvious reasons.

The data cleanse will not remove the null rows in the "Data" column. I am probably missing something really dumb. Original file generated in 2021.3.47945 and also rechecked in Version: 2020.4.5.12471

Many thanks

[ChrisTX · Accepted solution]

Your sample dataset has a column "Record" that has a non-null value.  The option for Remove null rows will only delete a row if all fields are Null.

Your original question mentioned the Data column.  But the option for Remove null rows is not related to any columns.

Chris

[Bobbins]

Apologies, I believed it would remove rows when selecting a column which contained blanks. My mistake.