filter specific data out of a database reader

#1

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!

0 Likes

#2

Hi @barnesrachele

Maybe the Reference Row Filter Node is helpfull?

gr
Hans

0 Likes

#3

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

1 Like