It is very easy to use the Trim Function in Alteryx. Here’s a quick guide on how to do it in simple steps:
- 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.
- Following that, configure the selected tool according to your liking. Type your preferred Output Column name and then specify its corresponding Field Type.
- Go to the Formula field afterwards, then type 'Trim' and select it from the suggested results.
- Subsequently, replace String with '[' and select the field that contains the data you want to edit.
- 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.
- Finally, the Trim Function will process your data and generate the corresponding output based on your configurations.
