Decimal point in KNIME

Kuldeep_Sachdeva · August 9, 2015, 6:14pm

when I upload a csv file in KNIME after excecution table shows number only upto three decimal point and I need information of atleast upto 7-8 decimal points.

Sanp shot is attached

knime.png

aborg · August 9, 2015, 11:39pm

Just change the cell renderer to full precision. (You can change globally in KNIME Preferences, or just locally by right-clicking on each column and selecting the renderer you prefer from the context menu.) The decimals are present in KNIME, just not visible by default.

Kuldeep_Sachdeva · August 10, 2015, 8:37pm

Thanks. It worked.

chilala · October 9, 2015, 11:44am

I output data into an .xlsx worksheet and would like the data fixed on 1 decimal...somehow can't find the option under KNIME Preferences i.e. instead of 1,666666, I want 1.7

blausch · October 10, 2015, 2:25pm

@ You can change globally in Knime Preferences

Where is the point in preferences, I searched for half an hour, but I probally overlooked it.
Can You tell me, where You found this.

Greetings

Berthold

aborg · October 10, 2015, 6:03pm

Hi Berhold,

I hope the following screenshot will help you find the setting (under File | Preferences):

blausch · October 19, 2015, 5:37pm

Thank You very much aborg.

Threre it is.

deicide_bg · March 11, 2020, 9:25am

For the sake of finding, I’d recommend leave those decimals on full precision, then round the result only where you need in a MATH node - round(x, y)