How do I filter a data by a listHi ,
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
Data TableRe: How do I filter a data by a listPlace 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.
