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