How to perform specific excel formula in knime
Hi there,
I need to perform the following excel formula on a column of data:
=IF(LEN(B2)>6, B2, C1)
This formula checks to see if the length in column b is greater than 6 and if it is then it returns the value from the row in column B and if the value is not greater than 6 it returns the previous value in column c. How could I perform this with Java or some other tool?