Reference row filter with database nodes concept

Hi collegues,

I'm trying to figure out how to perform the same kind of operation that is performed in Reference row filter node(so filter out the row that are not present in the reference table) but by using the database nodes. Since I have noticed that performing groupby and filtering rows/columns with database nodes is really much faster than the table node when we have to face huge volume of data.

I have seen the database row filter node but this is not the same as the reference row filter. node

Instead of haveing 2 knime tables in my case I would have I have 2 mysql tables.

Any help or suggestions for perform the same result but with database structures?

Thanks in advice!

-Giulio

Hi Giulio,

There isn't currently an equivalent for that node. It should be possible to write the SQL and execute that using the Database Query node.

Best,

Jon