Problems with Select

[David_Santamaria]

Hi guy´s
I have one problem whit UiPath, in activity Asing and Select from Data table.
I want to have information about the table based on a global variable that I have defined in the program which brings a value that is also found in the DATATABLE and I can relate it to the variable, but it does not allow me to search with my variable, it says that it does not exist , could you support me.

[saurabhB]

Please provide some more details, like a sample input database screenshot and the value of the global variable that you are using in select query

[David_Santamaria]

[quote=“saurabhB, post:3, topic:650448, full:true”]
Please provide some more details, like a sample input database screenshot and the value of the global variable that you are using in select query
[/quote

This is the selector query

This is format datatable

And i like use this Variable to filter the information

[saurabhB]

I think you have added some extra spaces while adding

" ’ "

I am very sorry I don’t use select command much, I use where condition it also works very similar way

DatosExcel.asenumerable.where(function(x) x(“REFERENCIA A.A”).tostring=trafico).CopyToDatatable

Now you can set the value of variable trafico to either string.empty or with required value to filter the whole table with column “REFERENCIA A.A” having value equal to trafico

I hope this helps
I will try to code using select query and update you

[David_Santamaria]

Tnks but i have the solution.
I would just like you to help me get one more piece of information.
I have this Object DataRow[2] { DataRow { HasErrors=false, ItemArray=object[8] { “Fenty”, “5984179”, “3003150”, “RU04299”, “8509”, “12.01”, “USD”, “27 familias, 32 modelo adicionales” }, RowError=“”, RowState=Added, Table=[Hoja1] }, DataRow { HasErrors=false, ItemArray=object[8] { “Fenty”, “5989775”, “3003150”, “RU04299”, “2813”, “98.05”, “USD”, }, RowError=“”, RowState=Added, Table=[Hoja1] } } and I need different fields of it.
For example “5984179” In data Row 1 in the 2nd posicion
But from all the data Row