filter specific data out of a database reader


Hi, I’m very green when it comes to Knime so bear with me. I have a database reader pulling 18 months worth of usage on hundreds/thousands of serial numbers, I do have a list of those specific serial numbers I only want to see, but what node do I attach to it? If i just run the database reader and attach it to an excel appender there are too many lines to export. So need to filter it down first. Thanks!



Hi @barnesrachele

Maybe the Reference Row Filter Node is helpfull?




I would recommend Parameterized Database Query node connected to the list of specific serials.

1 Like