How do I filter a data by a list

[#1]

Hi ,

I have a database which has 2 columns : S/N (serial number of the product) and  Value.

The S/N column my have duplications in the data it contains.

In addition, I have a list of S/N I would like to collect from the main database and manage separately.

If it was one or 2 S/N then I would do it by data filter tool, but the list I need to look for is fairly large.

any proposals how to do it easily?

Thank you in advance

Yonatan

[#2 · Accepted solution]

Place the list of S/N as a column in a new data table.  Then use

     Tables=>Join

to join the new table to the original large table.  The Join platform will let you create a new table with only the rows of data where there was a match in S/N.