No Rule Engine Lesson in L1-DW?

[kowisoft]

Dear KNIMErs,

I just looked through the official curriculum and discovered in the most current presentation I have there is nothing about the Rule Engine Node.

Is that really true that this is not “in scope” for L1-DW? Especially considering your latest focus on “escaping spreadsheet hell” this is a little bit strange as the Rule Engine (and the Column Expressions) Node is THE replacement for the probably most popular Excel function: the IF-Formula.

Thanks for some feedback

Cheers

[iCFO]

And this String Manipulation node trick that I learned from @takbb…

IF, OR, AND Statement Rule Engine

Just for the excitement of having yet another option ;-)… if you really want to, you can do nested if statements within String Manipulation too. It’s hidden away, but it’s there: e.g. string( $column1$.equals("Y") ?"Some result" :$column2$.equals("Y") && $column3$.equals("N") ?"A different result" :$column2$.equals("Y") ?"Yet another result" :"Bored now!" ) The syntax is condition ? result if true : result if false and as you can see, you can nest the conditions. It’s…

[emilio_s]

Dear @kowisoft ,

We are on the same page there, the Rule Engine is so essential and can’t be left out in our courses.
I did a quick double-check and, luckily, I can confirm that it is part of our self-paced and instructor-led material for L1-DW. Which material did you check out?

[emilio_s]

Personally, I am a big fan of the Column Expression node… but good catch!

[iCFO]

Same here. My most used node by a long shot!

[kowisoft]

Thank you for the feedback. I don’t know how I could miss it. I redownloaded the file and there it comes exactly where I have remembered it (after the Missing Value Node slide). Sorry for the confusion, maybe I accidentally deleted it.

SORRY again!