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

Alteryx Designer Desktop Discussions

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

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

Ram_RK
Asteroide

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 RESPUESTAS 6
flying008
Aurora

Hi, @Ram_RK 

 

You can try Data Cleansing tool to remove null rows. 

 

 

Ram_RK
Asteroide

Data clensing is not removing the null rows @flying008 

Ram_RK
Asteroide

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

flying008
Aurora

Hi,@Ram_RK 

 

Then you need use filter tool to get your want.

!IsNull([Field Name])
Ram_RK
Asteroide

that works perfectly @flying008  thanks for the help 

flying008
Aurora

Hi, @Ram_RK 

 

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

Etiquetas
Autores con mayor cantidad de soluciones