Fixed Decimal still shaving off ending zero

Hello! This used to work for me so I don't know what's going on.

My input is a list of loan balances, all amounts in my input file have two decimal places. Alteryx assigns data type Double to all the balances, which wipes out all zeroes after the decimal so I used a Select tool to set the column to Fixed Decimal (19.2) yet my results still come out with ending zeros missing. What's up with that? Kinda defeats the purpose.

Help

Accepted answers

IraWatt

@KateC Inputting as CSV would force Alteryx to input your data as string initally

All comments

IraWatt

Hey @KateC,

If you change the type over to String the fix decimals will auto format with the additional .00

Alteryx must have decided that the additional .00 made more sense to remove when looking at the data as a numeric type

Zeros.yxmd

KateC

I'm getting the same result. If Alteryx is assigning the numeric data type and removing the zeroes upon input, then changing to a string won't put the zeros back. Is there a way to get Alteryx to stop anticipating and just pull in everything as a string?

binu_acs

@KateC your input file is in which format is it .xlsx or csv?

IraWatt

@KateC Inputting as CSV would force Alteryx to input your data as string initally

KateC

Thanks @IraWatt! I'm so used to Excel everything I didn't even consider CSV. I'll go that route.

IraWatt

Awesome @KateC ! glad it worked

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703