How to remove Blank rows from my input data

[gagandeep_dhall]

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

[Emil_Kos]

Hi @gagandeep_dhall,

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

[echuong1]

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.

[kumarsmaganur]

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