ID do not show real numbers after extraction into excel/csv writer

Hi, I am connected through Athena to S3 buckets and I need to extract a table with an ID (a string with 16 numbers), but when I write this table into a csv or excel I see this ID with no real numbers but with all the same number approximate:

Instead of:
3101011619500008
3101011690526000
3101011619500017
3101011619500024

I see on the excel or csv:
3,10101E+15
3,10101E+15
(if I convert this field into numbers I see other numbers respect to previous ones:
3101011619500010
3101011619500020
3101011619500020
3101011619500020)

How can I extract the same original numbers into any format?
Many thanks
Giad

Hello giad,
which version of KNIME Analytics Platform are you using? I tried it with the latest one and the Excel Writer and CSV Writer do write out the full number and read it also back in without any losses (see attached workflow) if you disable the “Use Excel 15 digits precision” option in the Excel Reader node.
The problem with Excel is that it usually displays number with 15 digits only. But when you look into the data file within the xlsx file by unzipping the xlsx file (in the zip file got to xl/worksheets/sheet1.xml) you will see that all 16 digits are in the file but not displayed properly in Excel.
Bye
Tobias
ExcelLargeNumber.knwf (17.3 KB)

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.