In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to remove Blank rows from my input data

gagandeep_dhall
8 - Asteroid

Hi, 

 

I am importing excel files, but getting Blank rows in between the data.

Is there a way to remove Blank rows from the table?

 

Regards,

Gagandeep

3 REPLIES 3
Emil_Kos
17 - Castor
17 - Castor

Hi @gagandeep_dhall,

 

You can use the filter tool to filter out null positions or empty positions. 

echuong1
Alteryx Alumni (Retired)

A really easy way to do this is with a data cleansing. If you check off the options at the top, it will profile your data and remove any column and/or row that is completely empty.

 

This is an easier and safer way than using a filter because you won't have to include all fields in the condition to make sure you don't accidentally remove something you need.

 

echuong1_0-1614719971447.png

 

kumarsmaganur
5 - Atom

Data clense tool is not working, i mean isnt removing the null and blanks. What else to do>?

Labels
Top Solution Authors