Hi. I have a question. I have got an an integer type attribute called Num_of_Loan. It says to set the value to zero if the original values are negative. As I saw, there are negative values in num of loan. How do I replace them with zero?

Another question. two attributes num_bank_account and num_credit_card. It says to take their absolute values. How to do that?

Thanks. I appreciate the help

Hi @Ammar_74

Task one can be done with a Rule Engine:

```
$column1$ < 0 => 0
TRUE => $column1$
```

Task two is a job for the `abs()`

function.

@ArjenEX you have been faster

Hey @Ammar_74,

you could achieve the replacement of negative values with the Rule Engine – KNIME Community Hub node by using the following expression

```
$Num_of_Loan$ < 0 => 0
TRUE => $Num_of_Loan$
```

Regarding your second question Iam not sure what you want to achieve, maybe you could show some example values and what you want to output exactly.

Best regards

Lars

Thank you so much, it worked perfectly. BTW ,

About the second part abs() function. Which node do i use?

You can use the Math Formular node.

Hello. Sorry for bothering you. I have an attribute Num_of_Delayed_Payment. The task is to replace the non-numerical symbols and convert to integer format. I check that the non numerical values are 3_, _7 etc. I removed them using string manipulation. But there are also negative values such as -1 etc. Do I also remove the minus? Is minus a non numerical symbol? Also I will convert to integer type using string to number.

Thanks a lot!

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.