- Inside Alteryx's workflow designer, head over to the left-side panel and find the 'Select' tool. Drag it onto the main canvas and connect it to the Input Data tool or other sources.
- After that, head over to the right-hand panel and find the column that contains the decimals you want to remove. Tap the 'Type' menu next to it.
- Choose 'Integer' from the list.
- Finally, the decimals from the selected field will be removed from your dataset.
How to Remove the Decimals in Alteryx
Follow this interactive demo to learn how to remove the decimals in Alteryx.
📌 Why this matters
Removing decimals transforms your data into clean integers for calculations, reporting, and database compatibility. Many systems expect whole numbers for ID fields, counting operations, or financial calculations where fractional values create errors. Beyond basic formatting, this conversion prevents downstream issues when your data feeds into systems that can't handle decimal precision or when you need exact integer matching for joins and lookups. Converting to integers also reduces file sizes and improves processing speed in large datasets.
Your product deserves an interactive demo
Similar Articles
No items found.