Hi. I have an assignment to be done on Knime. I have data where I have an Age attribute. I have to remove the values which are <= 0 and > 120. I tried the following:
$Age$ <=0 AND $Age$ > 120 => TRUE. But it did not work.
Could anyone please help me with it. I tried it many times with different combinations but it does not work.
Thanks
Hello @Ammar_74
When you use the logical operator AND, you are querying the attribute $age$ to accomplish with the two conditions at a row, that in your use case is not possible. You should use OR logical operator.
Rule - Based Row Filter (exclude TRUES)
$Age$ <=0 OR $Age$ > 120 => TRUE
TRUE => FALSE
BR
1 Like
HI @gonhaddock
Thank you for the reply. I tried what you explained. But it still shows values such as 7850, 500 and many more. I don’t know if I am doing something wrong or what. I don’t know if its any help but this attribute is a string. I had to remove some - and _ from it which I did with the String manipulation
Thanks
Hi @Ammar_74
You can convert to number (String to Number - integer), and then apply the filter; if necessary you can convert back to string afterwards, with Number to String node.
BR
2 Likes
Hey @gonhaddock
Thank you sssooo much. It works. Please dont mind if I keep on posting question here about Knime. My assignment is due 14th (smiling_face_with_tear:)
Thanks again
3 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.