Good day,
Is there an easy way to convert a column type to a percent so that when the table is written to an excel file it is formatted as a percent?
Thank you!
Hi @mmays , I’m not sure what a “percent” type is or what format would a percent be. What would be the precision (decimal place) on that? I mean for example, what value do you expect as a percent for 1/3?
Knime would probably set the column do Decimal if you are doing calculations that results in floats
I think he just means to display it as a percent in Excel when it is written. There are 2 approaches. You can either format an excel “template” and then write your values to it using this… (Template just means an existing file, so you can write / format in excel, then use that as the formatting template for future changes.)
Or format the excel file using a series of Continental XLS formatting nodes.
5 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.