Getting exact row cell valu without using for each row

Help Activities
, ,
1

Hey Guyz, im trying to get the exact cell value for the column “description” of row “ES”

simply i just wanna use row index things like this= dtVariable.rows(2)(1).ToString

But its not working & giving error like at times row/column doesnt exist
Can you please help me fix this or any better approach to to the excat cell value
Thanks

image
image567×526 43.3 KB

2

Hi @Jiban_Stars

You can use Linq query to achieve it

use assign activity and the value should be as below
(From r In DT Where (r(“Language”).toString) .equals (“ES”) Select r).CopyToDataTable

Use output data table activity to convert datatable to string.
Reference
https://activities.uipath.com/docs/datatable-output-data-table

1 Like
4

Hey @Jiban_Stars , the right syntax is

dtVariable.Rows(2).Item(1).ToString

Hope this helps!

1 Like
5

Hi @Jiban_Stars

You can try with Lookup DataTable Activity

image
image1238×724 40.9 KB

Here is the workflow
Sequence.xaml (6.5 KB)

Regards
Gokul

1 Like
6

Thanks
let me try

8

Thanks Guyz, for all your responses

But that was a silly mitstake from my end

actually read range values were not defined clearly thats whts why it was giving me that error, my bad

yet Thanks again for all your responses

9

Kindly mark the appropriate post as solved, If you don’t have any query.

So that it will help others to

Regards
Gokul