How to use (like ,= operator) with column in Datatable.Select

datatable
code

#1

Hi,
I have one column containing both Integer and String value.
And I am using Datatable.Select here I am trying to select data but its showing error
You can not use = operator with string value and If I use LIKE operator it showing error
You can not use Like operator with Integer and String

Thanks,
Sandy


How to Compare CSVs having same Keywords
#2

@Sandy Before comparing the value using = or Like operator, are you concatenating the string value and the integer value together(Converting integer to string). Please share your code snippet of select statement being used.


#3

@Sandy

please chick this code

Datarow[]=datatable.Select(“column_name=’”+String_value+"’")

let us know if your facing any issue still.

Thank You :slight_smile:


#4

i faced a problem in similar scenario and I hopefully found a solution. Please refer to the link below

https://forum.uipath.com/t/filtering-a-row-in-datatable/9942