It is very easy to replace the null values with 0 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 Input Data tool or other sources.
- After that, go to the right-hand panel and make the necessary configurations. To get started, go to the Select Columns to Cleanse section and tick the checkbox beside the field you want to edit.
- Subsequently, scroll down to the Replace Nulls section and tick the checkbox beside 'Replace With 0'.
- Finally, the null values in your Alteryx workflow will be replaced with 0.
