logic filter

Hi there,

Have you plans for a logic filter, where a input can be filtered (numeric filters, AND,OR,NOT, LIKE etc), or transformations made. For example, if node input is ic50 then this can be changed to IC50, or if node input is CAR then node output is AUTOMOBILE etc, depending on a set of business rules.

Best regards,


In order to make a numeric row filtering, you could use the Java Snippet node by aggregating columns into a additional one and then use the Row Filter to filter accordingly to the appended column. To make this kind of easy transformations from ic50 to IC50 or CAR to AUTOMOBILE you also can use the Java Snippet node to enter Java-style commands. For example:

    $columnX$.equals("ic50") ? "IC50" : $columnX$