How to use new filter

Help Studio
, , , , , , , ,
1

Hello,

i need to check how many "no values are there in "Matching/not matching column.
so i am using filter activity , initially i used filter data table activity(classic).
so just tell me how to use this new filter , how to write condition

image
image261×339 1.96 KB

image
image722×398 12.8 KB

my requirement is if column contains 1 or more “No” then need to perform certain actions

hep me on same

2

Hi @Mathkar_kunal

Use the LinQ expression in a if loop condition

(From row In yourDataTable.AsEnumerable()
           Where row("YourColumnName").ToString.Trim.Equals("No")
           Select row).Count() > 1

Hope this helps!

3

ok and where to save output ?
like previously in filter data table we used to save in variable

4

If you just want to check for the condition no need of filtering and saving the filtered Dt it in a datatable variable

Glad it works!
Happy Learning :innocent:

1 Like
5

Hi @Mathkar_kunal
You can use linq , use assign activity
Place this ,
(From row In yourDataTable.AsEnumerable()
Where row(“YourColumnName”).ToString.Trim.Equals(“No”)
Select row).Count() > 1

Or else use filter datatable activity you can pass input and output strings with desired output you can use output datatable activity.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.