I want to filter a datatable based on 2 row columns. For example, dt.rows(0) = “” && dt.rows(3) =“some_name”
Is it possible to have a complex expression like this? The are 10 specific names in the 3rd column that need to filtered out on if the first column is blank. If the first column is blank but the 3rd column is no one of the specified names, keep the row. My issue is that, all rows that are blank in the first column are getting removed even if the 3rd column is not one of the specified names to remove.