It is very easy to remove the leading zeros in Alteryx. Here’s a short tutorial on how to do it:
- Inside Alteryx's workflow designer, head over to the left-side panel and find 'Formula'. 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 to make your desired configuration. To get started, enter your preferred name for the Output Column and set its Type according to your liking.
- After that, head over to the Formula field and type 'TrimLeft'.
- Subsequently, select it from the suggested results.
- Replace the String value with '[' and then select the field you want to edit.
- Likewise, delete the Y input and replace it with "0". Make sure that it is enclosed with open and closed quotation marks.
- Finally, the leading zeroes will be removed from the non-zero values of the selected field in your Alteryx workflow.
