Change Datatype to number

Hi all,

I want to change datatype from string(abc) to number(#) and convert the file to .tde, The problem is the value has 18 digits(0.564738273645638282), i tried select tool, formula tool(To numer function), but i didn't get same values. give me the idea to fix this one. please see the attached imgage for your reference.

datatype.png

Common Use Cases

Accepted answers

SophiaF

@DeepakKrish - Tableau defaults to show that many digits on the Data tab. Once you move the measure to the sheet of you choice, you can edit the formatting there.

fDlgVjs

All comments

SophiaF

The type 'FixedDecimal' should work for you, and you can change this within a Select tool. For fixed decimal, the number after the (.) is the number of decimal places you would like to keep - in this case, 18. Please see this article for more information about this type.This article gives more info about the FixedDecimal type.

63Zi1V0

DeepakKrish

It's working fine in alteryx, But when i stored the output as .tde file and opened in tableau ,it's again showing 8 digits only.

See the attached image.

Capture5.JPG

SophiaF

@DeepakKrish - Tableau defaults to show that many digits on the Data tab. Once you move the measure to the sheet of you choice, you can edit the formatting there.

fDlgVjs

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335