Assign variables in Select

[Snowman]

Hi @andrzej.kniola,

Just in case my previous reply confuse you.

@Snowman

DT.Select(“DT.Columns(0).ColumnName = '”+string variable+“’”).CopyToDatatable

With that syntax, I get the error: The expression contains undefined function call DT.Columns()

May I have your advice again ? Thanks so much.

[andrzej.kniola (Andrzej Knioła)]

DT.Select(“[" & DT.Columns(0).ColumnName & "] = '” & stringVariable &"’").CopyToDatatable
or in a more readable way:

string filterTemplate = "[{0}] = '{1}'"
string filter = String.Format(filterTemplate, DT.Columns(0).ColumnName, stringVariable)
DT = DT.Select(filter).CopyToDatatable

2nd option makes it also much easier to understand and/or modify as needed (and is very similar to what was in the Academy if I remember correctly).

[Snowman]

Thanks, let me try.

I have just passed only the basic one…

[Snowman]

Just a quick response to your option 1:

I typed: DT1.Select(“[”& DT1.Columns(1).ColumnName & “] = '” & StringA &“'”).CopyToDatatable

but get an error: Assign : Cannot perform ‘=’ operation on System.Double and System.String.

For Option 2, would you mind telling me what does “[{0}] = ‘{1}’” mean in the filterTemplate ?

[Snowman]

Hi @andrzej.kniola,

My bad, I think your option 1 should work, it is the problem of my excel file. I think I just need to change the values to string in my excel.

[Snowman]

Hi @andrzej.kniola ,

Just would like to share, after your advice plus some trials, that the datatable takes column0 as the column name for column index = 0, and column1 as the column index = 1, etc. The following works for me also:
DT1.Select(“[Column0] = '” & StringA &“'”).CopyToDatatable

[Bachali (Akhil)]

@aksh1yadav I want to use contains in select instead of equal can you please help me out of this??

[indra]

@Bachali you can use Filter Data Table activity

https://activities.uipath.com/docs/filter-data-table

[Bachali (Akhil)]

@indra I think it will work only in excel application scope but I’m using data scrapping and taking that in datatable. for that datatable I want to check whether my requirement is contains r not by using select function

[indra]

@Bachali you can use like keyword

How to use contains in a select from datatable

[sangasangasanga (sanga)]

cdr.Select(“Client=”+“‘“+serverName+”’”).CopyToDataTable

@aksh1yadav Hi i have tried your way, apparently mine gives me error. Could you help me with my lines