Hi, I would need your help on the issue: I have a dataset with 1000 drug names and I want to pattern match those drug names with the main Pharmacy Data set so that I can only get data for the drugs I have. Hard coding 1000 values is not an option here, so i'm looking for a dynamic solution. Both the tables have Generic Name column and I want to pattern match on these two. I want to use wildcard operator. Could someone please help? Thanks!
... View more