IF Statement

[Alsmaar]

I am trying to make this work

If Colum A is equal or less then 0 do plus 30 on the value in colum B. but for some reason i dont see how i can make this work

[rfeigel]

Try this:
IF Statement Column A_B.knwf (79.0 KB)

[Alsmaar]

thanks, so i tried it after adjusting the code to:

if ( (“availability-data-catalog-xxxx.csv”) <=0 ){
(“DELIVERY_TIME”) + 30
}
else(column(“DELIVERY_TIME”))

and it doesnt do the +30 on the value in the deliverytime column

[rfeigel]

What’s the data format of delivery_time? Its got to be a number.

[Alsmaar]

both are number (integer)

[rfeigel]

Post some sample data

[takbb]

Hi @Alsmaar, welcome to the KNIME community.

Generally a screen shot or ideally an upload of what you have actually done, along with some demonstration data, will make it quicker and easier for people to assist, otherwise it’s just a guess of all possible things you may have done or not done.

[Alsmaar]

Please let me know if this is helpful

I try to make the Delivery time go up by 30 if the availability-data-catalog-xxxx.csv column is equal or lower then 0. i tried it with a math block but couldnt make it work

[Alsmaar]

Thanks, i hope the above shown can help

[takbb]

Hi @Alsmaar,

I just spotted that if you compare the code from @rfeigel , you will see you are missing the function keyword “column( )” around your column names

if(column("A") <= 0){
    column("B") + 30
}
else(column("B"))

[mlauber71]

@Alsmaar might your first option miss a column() statement in the first if/else result?

Also the else just use the other brackets {}

KNIME Snippets (3) — Rules and Conditions do apply

[takbb]

Assuming that this resolves the problem, please mark @rfeigel 's earlier post as the solution, since that provided a solution to the original question asked.

[Alsmaar]

Aah yes that was the issue:) thanks

[rfeigel]

I’m not sure what you were doing when trying to construct the Column Expressions script. Don’t try to manually enter the columns. Single click the column button and then double click the column you want to insert. It will automatically insert where the cursor is located. The insert will be properly formatted, e.g. column(“B”).