Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

General Discussions

Discuss any topics that are not product-specific here.

Select Tool

ssalemi
5 - Atom

The Select tool removes zeros after comma. For example, it converts 1,000 to 1. The 'Use commas as decimal separators' box is unchecked.

What is the remedy for this?

2 REPLIES 2
Hub119
11 - Bolide
11 - Bolide

When converting numbers stored as strings (when they include a comma) into a number, your best bet is to first remove all non-number characters from the field before doing the conversion in the Select tool.  Using the formula replace([start],',','') where "[start]" is the name of your original text field should do the trick.

TUSHAR050392
11 - Bolide

You can also try to use ToNumber(Column Name) formula in the formula tool to convert string column into a new number column once get rid of string rows. In case you don't remove string rows, they will turn into 0.

Labels
Top Solution Authors