Alteryx Designer Desktop Discussions

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

How to remove null value Records completely from the data (Needed to remove complete row)

Ram_RK
8 - Asteroid

How to remove null value Records completely from the data (Needed to remove complete row)

 

One Column has Values + Null Values but needed to remove null value records Rows completely from the Data

6 REPLIES 6
flying008
15 - Aurora

Hi, @Ram_RK 

 

You can try Data Cleansing tool to remove null rows. 

 

 

Ram_RK
8 - Asteroid

Data clensing is not removing the null rows @flying008 

Ram_RK
8 - Asteroid

like if one column is Null its not removing the entire row  by using data cleansing @flying008 

flying008
15 - Aurora

Hi,@Ram_RK 

 

Then you need use filter tool to get your want.

!IsNull([Field Name])
Ram_RK
8 - Asteroid

that works perfectly @flying008  thanks for the help 

flying008
15 - Aurora

Hi, @Ram_RK 

 

If you get your want, please mark it as a solution for more share.

Labels
Top Solution Authors