ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Bangalore, IN

Welcome to the Bangalore User Group

Click the 'Join Group' button to get updates on group news and events.

Excel alteryx

MahanteshS
8 - Asteroid

How to remove empty or null  rows from excel?

3 REPLIES 3
Vijuzy
8 - Asteroid
Use filter tool to remove empty rows or you can also use data cleanse tool to clean the data

Data cleanse tool- https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Data-Cleansing/ta-p/31753

Filter tool- https://community.alteryx.com/t5/Alteryx-Knowledge-Base/Tool-Mastery-Filter/ta-p/85764
cypherboy
5 - Atom
rm.na=TRUE


AAKASH
MahanteshS
8 - Asteroid
What you mean by "rn.na" in above formula ?