Remove Blank Rows

[skeen503979]

Hello

How can I remove blank rows from my data?  My data source has a blank row every other row.  Is there an easy way in Alteryx to exclude the blank rows?

Thx

[clmc9601 · Accepted solution]

Hi @skeen503979,

One easy way is to use a macro, like the CReW Cleanse macro. It's available for free download here. 

Another way is to use a Filter tool on a single or multiple columns. F1 is not null.

[skeen503979]

Thank you @clmc9601.  That should work.

[Ar13f]

Dear @clmc9601 

I have downloaded the macro tool on your advice namely CReW Cleanse, there is a little problem as below

how to solve the above problem? need your advice ...

PS : my alteryx version is 2020.2

[Ar13f]

Dear @clmc9601 

I can save the CReW Cleanse in the macro folder but it doesn't appear when I want to use it.

[Priyanka_Ms]

@skeen503979 , you can also use the available 'data cleansing' tool and select the "remove null rows" as shown, for a short and quick workflow.

Spoiler

[clmc9601]

Hi @Ar13f,

This error is because the CReW Cleanse internally uses two other CReW macros-- I'm sorry, I didn't realize that before. All the CReW macros are available for free here.  Once you download and install them, the CReW Cleanse macro should work.