Decimals in Table tool

[BRRLL99]

Hi,

DATA	RUPEES	EXPECTED OUTPUT
A	0.02	0.02
B	0.01	0.01
C	0.01	0.01
D	0.01	0.01
E	0.007	0.007
F	0.05	0.05
G	0.02	0.02
H	96	96
I	95	95
K	94	94
L	92.7	92.7
M	87.5	87.5

I would i like to show decimals if present in column

[FilipR]

I'm not sure what the issue is. Could you attach your workflow? Or create one that replicates the issue?

Please make sure you have the data type Double or Decimal selected.

[BRRLL99]

decimal has been selected in the table tool

let's take ex:

IF value is 1351 then it should be 1351

IF value is 25.50 then it should be 25.50

IF value is 0.007 then it should be 0.007

All these values are in one column

[FilipR]

I'm not sure where you get the issue. Alteryx does not remove decimals by default. It only does when you change your data type to integer.

Are you sure the issue is in Alteryx, and not in... for example, the SQL query you use as your input?

[BRRLL99]

when i'm table tool by selecting 3 decimals places

result                                 Expected result

1351.000                        1351

1225.000                        1225

0.007                               0.007

0.010                             0.010

56.000                           56

[FilipR]

Hold on, I see it now.

[FilipR]

Please see attached.

[BRRLL99]

as you can see in the data set

result

1351.000

1225.000

0.007

0.010

56.000

expected result

1351

1225

0.007

0.010

56

[FilipR · Accepted solution]

Yeah, my previous solution will work: