I do not think the filter wizard is the best way to achieve this. See here:
If you’d go for the last variant, LINQ, the expression would be something like this:
(From row In MyDataTable.Select()
Where (row(“col_1”).Equals(“something”) && row(“col_1”).Equals(“something”))
|| row(“col_3”).Equals(“something”)
…
Select r).CopyToDataTable
? Here are some LINQ snippets to look at:
But as you see this is not so elegant.
What about filtering the table one time for (Cond_1 AND Cond_2 AND Cond_3), one time for (Cond_4 AND Cond_5), and so on? This would give you several output tables. Sometimes this is useful. It depends on what you want to do with the data table.