Remove Empty Columns - WhiteSpace Error

I used the “Remove Empty Columns” transformation (empty values and whitespace) and it removed columns where there are values.
When I just selected the empty values (and not whitespace), it worked as expected.
Can you help me explain why this happens?

The help article on this transformation has been updated to explain how it works:

If it doesn’t answer your question, please provide an example where its behavior is not clear.


Just following up here - if there is a visible number/text in any row of a particular column, that column should NOT be removed if I select option two (“Remove columns where all values are empty or whitespace”) - is that correct?

Yes, that’s correct. If there is at least one visible value in a column that column won’t be removed in any case.