Handling Null values in Alteryx with Data Cleansing Tool | Vaibhav Gupta

In this video, Vaibhav Gupta is explaining that how we can handle null values in alteryx by utilizing Data Cleansing Tool and covering all sets of configurations required with live example.
You can also learn more about alteryx by visiting following links:
Alteryx Beginner Video:
• #Alteryx Mini #tutoria...
Alteryx Core Certification Video:
• EP 8:Alteryx Core Cert...
Crack Alteryx Interview Video:
• What is Alteryx|3 Step...
Basic Alteryx Batch Macro:
• Build your first Alter...
Controlling Container via. Batch Macro:
• Controlling Alteryx Co...
You can always reach out to me (Vaibhav Gupta) at:
Linkedin- / vaibhav-gupta-89b68b36
Instagram- / imvaibhavg
Twitter - / imvaibhavg
You can also book 1:1 session with Vaibhav at: topmate.io/imvaibhavg
If there are any other areas you would want me to cover for a video, please do comment below or you can always reach out to me at [e-mail]

[@abhz008]

Thank you...please cover Dynamic input, dynamic select and dynamic update tools :)

[@DigiBytes]

@Abhishek: We are glad that you liked our video. For sure we will cover these topics in upcoming videos.

[@manickganapathy8941]

Hi I need to filter records that have particular field value as null . when i try to use filter option for achiving this am getting both kind of records that have field value as null and also records that dont have the field value existing at all. I took the data from dynamodb so few records wont have that field . please help me figure out to filter only records that have the field existing but its value is null

[@DigiBytes]

@Manick: Thanks for reaching out. Please use the expression isnull([fieldname]). If it doesn't work, please share your dataset and we will quickly test and help you with the working expression.

[@sandro149]

Thanks for this explanation. What should I do if I want to remove the entire row? This 'remove null rows' doesn't work?

[@DigiBytes]

Yes, you can utilize "remove null rows" to remove entire null rows or you can write a filter condition using filter tool to filter them out.

[@sumitchaudhari5815]

@@DigiBytes how? if possible make video on it. using filter we can only select one column is it contains null or not i only want to remove those rows whose all columns contains null means row with all null values suppose i have one row which contains values but another row which is completely null so how to remove it please show it.

[@DigiBytes]

@@sumitchaudhari5815 : There are various ways to achieve it. The simplest is to concatenate all the columns in the filter condition and look for not null values. For sure we will create video for different ways of doing it.

[@yedukondaluboda5328]

Bro can you also tell us how to remove column in the same tool

[@vijendharp6766]

You cannot remove a column with the data cleansing tool. You can do that via select tool, just unselect the checkbox for the column in the select tool.

[@DigiBytes]

@yudkondaluboda5328: We can only remove columns which has completely null data using Data Cleansing tool but for removing other columns you have to use select tool or if you are implementing any joining condition within the flow, you can also utilize join tool for removing columns.

[@beingrishi6450]

Usage of Formula = Temp - Null() is completely useless

[@DigiBytes]

@rishikalpamukherjee1339: Yes you are correct Temp - null() is completely useless in our scenario as we have by default assigned temp = null() for checking the functionality of the different options of Data Cleansing tool.