How to Remove the Leading Zeros in Alteryx

‍

It is very easy to remove the leading zeros in Alteryx. Here’s a short tutorial on how to do it:

1. 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.
2. 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.
3. After that, head over to the Formula field and type 'TrimLeft'.
4. Subsequently, select it from the suggested results.
5. Replace the String value with '[' and then select the field you want to edit.
6. Likewise, delete the Y input and replace it with "0". Make sure that it is enclosed with open and closed quotation marks.
7. Finally, the leading zeroes will be removed from the non-zero values of the selected field in your Alteryx workflow.