How to Use the Trim Function in Alteryx

‍

It is very easy to use the Trim Function in Alteryx. Here’s a quick guide on how to do it in simple steps:

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. Following that, configure the selected tool according to your liking. Type your preferred Output Column name and then specify its corresponding Field Type.
3. Go to the Formula field afterwards, then type 'Trim' and select it from the suggested results.
4. Subsequently, replace String with '[' and select the field that contains the data you want to edit.
5. Replace Y with the specific character you want to trim from your data. Make sure that you enclose it inside a pair of quotation marks.
6. Finally, the Trim Function will process your data and generate the corresponding output based on your configurations.