Help with Filter Data Table Issue

[jwetherin]

So the below I am filtering for certain rows in my Filter Data Table. I am only taking rows where column 0 is “Service” or “Medical Practice”.

If I take out the Filter Data Table and just copy everything it replicates the exact data, so I have my flow setup right except when I put the Filter Data Table into the sequence, it runs but simply won’t paste anything into the other sheet. I also tried to enclose the index with the parenthesis as well. No errors it just won’t paste.

[Anil_G (Anil Gorthi)]

@jwetherin

What you need is an or condition and you selected and condition there…so no rows will satisfy please change the and to or

Also if you need multiple filters as nested filter is not possible use separate filters for each type of column unless you have only ine value for a column to filter

Cheers

[Ehab_Sawars]

replace first And with Or and use many filter datatable activities or you can go for linq query check below code assign it to variable datatable and check results

dt_filterdata = rangerd.AsEnumerable().Where(Function(row) _
(row(0).ToString = “Medical Practice” Or row(0).ToString = “Service”) And _
row(1).ToString = “Total” And _
(row(3).ToString = “Access Overall” Or _
row(3).ToString = “Care Provider Overall” Or _
row(3).ToString = “Likelihood of recommending” Or _
row(3).ToString = “Ease of contacting” Or _
row(3).ToString = “Ease of the registration process +” Or _
row(3).ToString = “Ease of scheduling appointments”)).CopyToDataTable()

[jwetherin]

Thanks. I just didn’t have the logic right at all. This works