Alteryx vs KNIME migration

To add @Data_consumer , the Table to HTML string node is the way to go here to include a nicely formatted table in your email:

As mentioned, you can add the table as flow variable to the email.

I can also recommend looking into CASE Switches. Meaning, if a certain condition is fullfilled, send out a certain type of email.

For the switch to work, a rule evaluation has to be in place that can be done with various nodes. Here I choose a Column Expression:

if (column("upload_status").equals("Done")) {
    0
} else if (column("upload_status").equals("Failed")) {
    1
} else {
    2
}

This reflects which port of the switch will be “activated”.

8 Likes