It is very easy to remove the null rows in Alteryx. Here’s a short tutorial on how to do it in simple steps:
- Inside Alteryx's workflow designer, head over to the left-side panel and find 'Data Cleansing'. Drag this tool onto the canvas and connect it to the Text Input tool or other sources.
- After that, go to the right-hand panel and configure the tool based on your preference. To get started, tick the checkbox beside 'Remove Null Rows'.
- Subsequently, access the Select Columns to Cleanse section and tick the checkbox beside the fields that contain the null values you want to remove.
- Finally, the null rows from the selected fields in your Alteryx workflow will be removed.
.gif)
