I have a DT I want to filter using the following code
db_in.Select("[NAME] NOT IN (" +r1_1+ “) AND [VALUE] NOT IN (” + r1_2 +")").CopyToDataTable
the variables r1_1 and r1_2 contains strings of multiple values, so I’m not able to use Filter Data Table.
My issue is that I have a table that contains the values A, B, C and D (NAME) and Values 1,2,3 and 1, where the variable r1_1 contains A, B and C and r1_2 contains 1,2,3. By my reckoning, the code above should filter all values except for D 1. However, it filter D 1 as well, so it seems the AND operator isn’t really working, it’s just filtering based on both variables individually. Any suggestions?