Hello,
I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom query. This seems like a no brainer but I am having trouble finding an easy way to do this from Query Builder. The answer likely lies in the "custom expression" as there are not a lot of options, but to manually enter in e.g. "t1.mfgID = ######## or t1.mfgID ######### or ..." is not realistic for repeatability.
Thanks for any help!
