I need to duplicate data from the row above for a single column based on a condition
Hi,
I am pretty new to the KNIME Platform and was wordering if there is a way I can write a condition where based on the string input I am able to either select data from the column data from the row right above it or leave it as the same.
Using String Manipulation I was able to get this:
regexMatcher($Customer Name$, “XYZ”).equals(“True”)?string($$CURRENTCOLUMN$$($$ROWINDEX$$)):string($Customer Name$)
This only gives me the row index of the column above and not the data itself.
How I can I change this expression to give me data from Customer Name -1 row?