How to use data table select in boolean type

[delf]

Hi there,

Happy new year for everyone,

I have a question regarding an if statement.

How i can use a statement where im using data tables as the condition.
Because it can’t use data table type in boolean.

For example i want to use this statement that im using in for each (example below)

DTtes.Select(“Convert([text], ‘System.String’) not like ‘%tes1%’ and Convert([text], ‘System.String’) not like ‘%tes2%’ and Convert([Assignment], ‘System.String’) not like ‘%tes3%’”)

and write that statement in if statement.

I’m really stuck as of now.

Really need some help for this issue.

Thank you and will be waiting for your kind suggestion

Best Regards

Delf

[KarthikByggari]

Are the text and Assignment, column names in the data table?
The datatable.select function not returns boolean. So you cannot use the expression like that.

datatable.select will return an array of data rows.
For example: DTtes.Select(“Column1=‘test1’”) , will return the array of data rows where Column1 has a value test1.

Are you trying to compare the value against all the data rows?

Regards,
Karthik Byggari

[delf]

Hi Karthik,

Yeah im trying to get the value that exclude the test1,test2 and others in column names.
basically im using that expression in for each row activity but since when im running the bot while the excel is not have that data (test1,test2,test3) it will return an error the source contains no data row.
Thats why im gonna using if activity so the error can be avoided.
Or there is another option for this problem?

Thanks a lot for the feeback

BR

Delf

[KarthikByggari]

@KarthikByggari

DTtes.Select(“Column1=‘test1’”)

Create a variable drFiltered (datatype: Array of DataRows)
Assign Activity,

drFiltered = DTtes.Select( “text not like ‘%test1%’ AND text not like ‘%test2%’ AND Assignment not like ‘%test3%’”)

Use if condition like below -

if drFiltered.Length > 0 Then
…

[delf]

@KarthikByggari

drFiltered.Length > 0

Hi @KarthikByggari

Thanks for the solution and its works like a charm.

Best Regards

Delf