Write Excel - Rounding integer strand to 100's digit

abevensee

I have a process that ends by writing results to an excel document. The output are account numbers meeting a certain criteria. When viewed through the results port, the entire account number shows up (Ex.1). However when the process ends with the "write excel" operator, it is rounding the account number to the nearest hundred (Ex.2). I have the operator set up to write to .xlsx and show all numerical fields as whole numbers (Ex.3). Any idea what would be causing this or ways to circumvent it?

Thanks!

Ex.1:


Ex.2:


Ex.3:

rfuentealba

Hello @abevensee,

If you say "account numbers meeting a certain criteria", is it that the account numbers are texts? Because a workaround would be to work with these account numbers as text/string and not as numbers. I can confirm that when generating numbers, those must stay within a range of 15 digits, which is less than ideal for other situations where a number can be large enough to overflow the definition of bigint/decimal.

Am I doing anything wrong here, @sgenzer ?

All the best,

Rod.