Fixed Decimal still shaving off ending zero

[KateC]

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.

[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

[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?

[binuacs]

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

[IraWatt · Accepted solution]

@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 :)