Null Exclusion from data

[Shaaz]

Hi, I've a set of data in excel file with 5 records.

From excel point of view, there are 5 records (when we open excel file) but Alteryx gives me 14 records. I was able to get 5 records by adding a filter and using isempty() function for all the fields. Since the fields were less, I was able to manage but how do we handle this if we have more than 50 or 60 records.

Attached is the workflow with data for your reference.

[LordNeilLord · Accepted solution]

There are several tools available on the gallery that can handle this....I have this one installed:

Remove Nulls

[Shaaz]

This worked and solved my issue but I've a question on this, what if I've space in my excel file instead of null or a combination of Null and spaces in multiple columns ? How can we handle this

[Shaaz]

Data for reference