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
Solved! Go to 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.
Thank you @clmc9601. That should work.
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
Dear @clmc9601
I can save the CReW Cleanse in the macro folder but it doesn't appear when I want to use it.
@skeen503979 , you can also use the available 'data cleansing' tool and select the "remove null rows" as shown, for a short and quick workflow.
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.