Linq query not working for negative scenarios

[rakshithms]

Hi Guys,

I have a query to get data based on some specific column

(From r In DT Where (r(“column name”).toString) .equals (“xyz”) Select r).CopyToDataTable

This doesn’t work in negative scenarios as in if value xyz is not present, how do I proceed

[nikhil.girish]

Hi @rakshithms

So I got your concern so if you have this kind of scenarios have a if condition with expression below

(From r In DT Where (r(“column name”).toString) .equals (“xyz”) Select r).Count>0

If count is greater than zero
Then you can go with your assign activity
With above linq you have posted

Hope this helps

[rakshithms]

Thanks man will check this part