It is very easy to replace the null values with blanks in Alteryx. Here’s a short tutorial on how to do it:
- Inside Alteryx's workflow designer, go 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.
- Following that, tick the checkbox beside the column you want to edit.
- Under the Replace Nulls section, tick the checkbox beside 'Replace With Blanks'. Take note that this option works on string data.
- Finally, the null values from the selected field in your Alteryx workflow will be replaced with blanks.
.gif)
