Getting error when adding two conditions

[manoj2500 (robo)]

hi

steps
1.read and excel saved in dt
2.now status is a datarow type when i add single condition where dt.select(“name = ‘tom’”) this works but when i add second condition its showing error i want check for both condition and get all rows as per that

[Rahul_Unnikrishnan]

Hello @manoj2500

Can you please share the full expression that you are using and the error that you are getting?

Thanks

[manoj2500 (robo)]

dt.Select(“name = 'tom '” ) And dt.Select(“call = ’ 2’” )

@Rahul_Unnikrishnan

[keerthi3595 (Keerthana M)]

Hi @manoj2500 ,
Can you try below expression instead

(from row in dt where row(“name”).tostring=“tom” and row(“call”).tostring=“2” select row).copytodatatable

[Rahul_Unnikrishnan]

OutDatatable = dt.Select(“name = ‘tom’ AND call = ‘2’”).CopyToDataTable

OutDatatable is a datatable variable

dt is the input variable(Datatable variable)

[RajKumar_DC (RajKumar Durai)]

Hi @Rahul_Unnikrishnan,

I have one doubt. Im getting exception if Name with apostrophe symbol(').

Without apostrophe symbol(') then fine

Thanks,

[Rahul_Unnikrishnan]

Are all the names having this apostrophe? Here this symbol is making the expression invalid.

else maybe you can try to split the name and join using + symbol. but it will not be the corerct approach.
Thanks

[RajKumar_DC (RajKumar Durai)]

Hi @Rahul_Unnikrishnan,

No only a few values
getting same error split join not working and thank you for your try

Thanks,

[Rahul_Unnikrishnan]

Instead of spliting it inside the Select method, you need to it outside and pass that value as a variable to the select method. I think that should work.

Thanks

[RajKumar_DC (RajKumar Durai)]

bad luck it not work any way thank you for your efforts

Thanks,
Rajkumar

[keerthi3595 (Keerthana M)]

Hi @RajKumar_DC,

Can you try below expression instead

(from row in dt where row(“Col1”).tostring=“Ma Do’na” and row(“col2”).tostring=“yourfilter2” select row).copytodatatable

[RajKumar_DC (RajKumar Durai)]

Hi @keerthi3595,

Thank you for your Knowledge, this is working fine but i trying via filter method not Iterate method if any possible about select method.

Thanks,

[keerthi3595 (Keerthana M)]

Hi @RajKumar_DC ,

Just double the quotes that comes in between the filter

Dt_Table.select(“Col1=‘Man Do’‘na’”)

if you want to add it dynamic

Dt_Table.select(“Col1=”+str_youfilter.replace(“'”,“‘’”)+“'”)

[manoj2500 (robo)]

@RajKumar_DC @Rahul_Unnikrishnan @keerthi3595
by using datatable it will throw error if there is no datarow that is why i was using datarow how to deal with that error

[keerthi3595 (Keerthana M)]

Please use the below in condition

(from row in dt where row(“name”).tostring=“tom” and row(“call”).tostring=“2” select row).count>0
or
Dt_Table.select(“Col1=‘Man Do’‘na’”).count>0

[supermanPunch (Arpan)]

@manoj2500

by using datatable it will throw error if there is no datarow that is why i was using datarow how to deal with that error

Hi @manoj2500 ,

Maybe a more clearer info on the error received would help us to understand what logic needs to be handled. For a Quick help, Check if the below post will be able to resolve your error :

[FirstAid] Handling of The source contains no DataRows exception

This FirstAid Tutorial will describe how a the source contains no DataRows EXCEPTION can be handled. Introduction Let’s have a look at the following filter data table scenario: Name CCode Tom US Charlotte FR Seema IN Jean FR Assignment: Filter all rows on a particular Country Code like FR, UK, ES, UK… Ensure that all CCode data column values are trimmed Ensure that the Filter check is case insensitive we can implement it e.g. with the help of a LINQ statement: dtData.As…

[postwick (Paul)]

Why don’t you just use Filter Datatable activity? It’s what it’s for.