Column Expression node

[Subramanyam]

Hi Team,

As I am new to knime I am facing an error while using IF Else condition with AND and OR logical operators.

Please correct the code

IF [PO Price per PC]>=(([Std Cost per DZ]/12)-1)
AND column([PO Price per PC])<=(([Std Cost per DZ]/12)+1)

OR isMissing([Std Cost per DZ])

THEN “Current Qtr”

//Elseif [PO Price per PC]>=(([Std Cost per DZ]/12)-1)
//AND [PO Price per PC]<=(([Std Cost per DZ]/12)+1)

//then “Previous Qtr”

//ELSE “Current Qtr”

ELSE “”

ENDIF

Thanks,
Subash

[HansS]

Hi @Subramanyam

What is wrong with this expression…?

How does your input looks like? And what is the output that you expect? What is the error / miscalculation ?

Please come up with a dataset.

gr. Hans

[iCFO]

Maybe double check that your calculations are being pointed toward columns that are number data types instead of strings? Always easier to share an example workflow with dummy data that highlights your issue.

[takbb]

Agreeing with @HansS and @iCFO that providing a sample dataset/workflow and a description of what you are wanting to do is more likely to help people to help you than simply supplying some code (in “some other language”).

It looks like you are trying to use Alteryx code (I’m guessing) which does not use the same scripting language as Column Expressions.

The Column Expressions node scripts are based on javascript, so you may wish to acquaint yourself with some basic javascript from a tutorial site such as this:

JavaScript If-Else and If-Then – JS Conditional Statements

Also, take a look at the examples in the following forum post which may give some pointers:

If Then Statement Conversion from Alteryx to Knime

Hello, I need help converting an If Then Statement from Alteryx to Knime. I’ve tried the String Manipulation, Rule Engine, and Column Expression nodes but can’t seem to get it. Which node should I use and what is the Knime syntax for the below expression? if contains([Loc Num],"-") then “SN.”+ [Loc Num] elseif IsNull([Loc Num]) then “” elseif IsEmpty([Loc Num]) then “” elseif Length([Loc Num])<=7 then “SN.”+ padleft([Loc Num],7,“0”) elseif Length([Loc Num])>7 then “SN.”+ [Loc Num] else …

Hopefully bringing that information together will help point you in the right direction.

All that being said… AI can be quite good for giving a quick-start with code conversions. For example, chatGPT suggested the following conversion, so you could give it a try with your dataset and come back with further questions if it still isn’t working.

if (
  column("PO Price per PC") >= (column("Std Cost per DZ") / 12 - 1) &&
  column("PO Price per PC") <= (column("Std Cost per DZ") / 12 + 1)
  || isMissing(column("Std Cost per DZ"))
) {
  "Current Qtr"
} else {
  ""
}