We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Deleting decimals from a number

Cfdiaz2103
8 - Asteroid

Hi guys,

 

Is it possible to delete decimals from every number of a specific field?

 

Here's a look of a sample of the data I currently have:

 

Input

12373.54

3127391.5

123.43

63232.7

12335

1235576.89

1230044.00

1265654.54

 

and here's the desired output:

 

Output

12373

3127391

123

63232

12335

1235576

1230044

1265654

 

As you can see, there's no an existing rounding process for each number. It´s simply trimming their corresponding decimals.

 

I'd appreciate any kind of support.

4 REPLIES 4
gautiergodard
13 - Pulsar

Hello @Cfdiaz2103 

Changing the data type to an integer should do the trick.

You can do this using a select tool, and select Type = Int16 for example.

 

Luke_C
17 - Castor
17 - Castor

Hi @Cfdiaz2103 

 

Try the floor() function

Luke_C_0-1665670975735.png

 

Sebastiaandb
12 - Quasar

@Cfdiaz2103 @gautiergodard 

 

Select tool and change type to Int32 does it :-)

DataNath
17 - Castor
17 - Castor

The Integer solutions offered won't work as they'll apply rounding during the conversion which you said you don't want/need. Best and simplest solution here is to go with the floor() function as mentioned by @Luke_C.

Labels
Top Solution Authors