Removing all the null rows

[Thiviya]

Hi,

I have used the data cleansing tool but still the blank rows are not removed. How can I remove these blank rows? 

I have attached the workflow screenshot to show using the data cleansing tool and also the results.

[caltang]

Try selecting all.

[Qiu]

@Thiviya 
Blank(Empty) and Null are different value in alteryx/😁
At least we can see that the Filter tool before your Cleansing tool will generate "Empty" value for field "Tax Team review".

That is why the "Remove null rows" will not work since there is value "Empty".

[caltang]

Also, adding to @Qiu 's point... @Thiviya I see in your data cleanse tool that you selected "All Whitespace" to be removed as well. Are you sure about that? Removing all whitespace removes all the spaces too. May change the meaning of your data entirely. 

[Thiviya]

Hi, 

Thanks for the details. So how do I remove all the blank rows from the output results ?

[caltang]

We attached the workflows for your reference above. Kindly download them and study it. Then apply it. You should be able to get what you want from there.

[Thiviya]

Sorry I have followed the screenshot for the ones after the filer tool still not working. I am getting empty rows between datas.

[Thiviya]

Here is full workflow and results

[Thiviya]

I have sort it out.. I have used the filter by "Is not empty"...