How do I filter a data by a list

YonatanK — Sat, 10 Jun 2023 23:46:26 GMT

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

Re: How do I filter a data by a list

txnelson — Mon, 28 Mar 2022 06:48:31 GMT

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.

topic Re: How do I filter a data by a list in Discussions

How do I filter a data by a list

Re: How do I filter a data by a list