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:
I see on the excel or csv:
(if I convert this field into numbers I see other numbers respect to previous ones:
How can I extract the same original numbers into any format?
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.
ExcelLargeNumber.knwf (17.3 KB)
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.