Currency Format

KNIME Analytics Platform
1

Hi and Good Day!

Is there a way we can format a number in a column into currency type? I have a column named list price and I am adding a dollar sign. The only option I am seeing is a String Manipulation using this expression: join(“$”, string($List Price$)) but this will convert the data type to string not like in excel where is an option to format the number into currency type.

Your suggestions and opinion is greatly appreciated.

1 Like
2

Hi @dantesalem ,

you are right, the current way to do this is as you described. We are aware that this is not ideal, but did not get to extending the Number Format Manager – KNIME Community Hub, yet (internal ticket reference AP-22082). I added a +1 for you to the ticket. Additionally, you can add your vote to Reporting Nodes: Number Format Manager with Percents and Currencies .

Thanks for the feedback,
nan

2 Likes
3

I already casted my vote. I hope we can add this feature since this is very important format.

1 Like
4

I found a workaround regarding the currency formatting, I used the Phyton script node to run an excel macro that will perform the formatting.

5

If the formatting was for Excel output and not within KNIME, then you should try out the Write to Excel Template node. It allows you to write into an existing formatted excel file with data from KNIME, or create a new file based on another template file.

You could also look into the Continental formatting nodes if your format is highly variable and you don’t have a lot of conditional formatting experience in Excel.

I would like to see currency or fixed decimal data types in KNIME as well though.

3 Likes
6

If your target system is Excel you could also employ Openpyxl for formats

or the continental package

2 Likes