Math Formula - Using column headings with '$'

[Rokank]

I am trying to use Math Formula where my column headers have ‘$’ signs in them.

However, because math formula uses ‘$’ to identify the beginning and ending of a Column Name, I am getting an error.

For example,

Column 1 Name: Cost ($)
Column 2 Name: Tax ($)

Math formula: Cost ($) + Tax ($)
Knime Math Formula: $Cost ($)$ + $Tax ($)$

Thanks in advance

[armingrudd]

Hi @Rokank,

You can use the Column Expressions node instead.

[Snowy]

While this is a solution, is there a solution using the Math Formula node? I’m curious because I’ve noticed the math formula node calculates significantly faster than the column expressions node.

[armingrudd]

Actually it seems the node tries to escape the dollar sign inside the column name but for some reason it fails. So if you want to use the Math Formula, you have to rename columns and replace the dollar signs. I think the best approach to do that is using the Column Rename (Regex) node:

This is an example expression after replacing dollar signs:
$Cost (＄)$ + $Tax (＄)$

You can copy and paste the alternative dollar sign in the expression to the “Replacement” option of the Column Rename (Regex) node.

[ipazin]

Hi!

@Snowy

is there a solution using the Math Formula node?

Unfortunately not for now. But a workaround @armingrudd suggested seems pretty good to me.

Br,
Ivan