... and I should have mentioned from the start that I'm doing this in
Google Sheets.
On Tuesday, July 4, 2023 at 3:03:33 AM UTC-5 Glenn Barker wrote:
> Thank you. I tried, but no luck.
> I know I could use a JOIN function to create the string *(value 1, value
> 2, ... *) from the column of
Thank you. I tried, but no luck.
I know I could use a JOIN function to create the string *(value 1, value 2,
... *) from the column of values (numbers in text) that I want to use as
the query key, but unfortunately (according to the Google Visualization API
Query Language
Have you tried using the IN operator which is a standard method for SQL. If
non numeric you need to enclose values with single quotes.
HTH
SELECT *column_name(s)*
FROM *table_name*
WHERE *column_name* IN (*value1*,* value2*, ...);
On Tuesday, July 4, 2023 at 1:41:57 AM UTC+1 Glenn Barker