Get row value based on column value

[vineelag (vineela27)]

Hi ALL,

I want to get AGE value based on Row Value NAME You can see below

Please kindly let me know the solution for this

Thank you.

[Quenton_Wayne_Rebello]

(From row in dt.AsEnumerable
Where row(“Name”).ToString.Equals(“ganesh”)
Select row(“age”)).ToString

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @vineelag ,
You can use read range to get data table as dtData
create variable strAge
for each row
if
row(“name”) = “ganesh”
→ asign strAge = row(“age”)

regards,
LNV

[vineelag (vineela27)]

Hi @Nguyen_Van_Luong1

but its dynamic,

like when ever i get ganesh name i need to know age

Once i done with ganesh if get rahul name then i need to get rahul age

[vineelag (vineela27)]

Hi @Quenton_Wayne_Rebello

but its dynamic,

like when ever i get ganesh name i need to know age

Once i done with ganesh if get rahul name then i need to get rahul age

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

create variable strName
change value of strName, will find value Age

[Quenton_Wayne_Rebello]

(From row in dt.AsEnumerable
Where row(“Name”).ToString.Equals(“var_Name”)
Select row(“age”)).ToString

Note:- var_Name is a variable that stores the name like ganesh, rahul etc

[Yoichi]

Hi,

Can you try the following sample using Dictionary?
This assumes name is unique in the table.

Sample20230817-7L.zip (8.5 KB)

Regards,

[tazunnisa.badavide (Taj)]

new.xaml (11.8 KB)
Hey I have attached the workflow here!
hope it might help you!

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @vineelag ,
I created wf and file input
have dialog,
you can enter name to find age
input(sheet3)
test.xlsx (11.4 KB)

code
tsst.xaml (17.4 KB)

you can try

[vineelag (vineela27)]

@Nguyen_Van_Luong1

I am getting like this, you can see on the Img

[postwick (Paul)]

This activity does exactly what you need.

https://docs.uipath.com/activities/other/latest/workflow/lookup-data-table

[vineelag (vineela27)]

@postwick

I am just able to see these packages only,

Not able to see remaining activities

[postwick (Paul)]

The other activities are in Programming and Workflow at the bottom which you need to expand. Or you can use the search box at the top.

[vineelag (vineela27)]

@postwick

I was Updated my

[postwick (Paul)]

Click the filter and select classic and see if it’s there.

What dependencies do you have installed?

[vineelag (vineela27)]

@postwick

got it

Thank you

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

oh, dont care about in comment, you need edit file path only

this is new file no comment

test.xaml (13.5 KB)
regards,
LNV

[vineelag (vineela27)]

Hi @Nguyen_Van_Luong1

Thank you so much but i need to compare once excel value in another excel value

for each excel1 value if its contains excel2 or not if yes need to increase the count by adding one (example age is 33 and its from excel1 and contains excel2 so need to increase the final count be 34)

you answer partially correct but need to compare two excels value.

Please let me for this.

Thank you

[vineelag (vineela27)]

Hi @Yoichi

firstly thank you, you answer is partially correct but i need compare

for example,

excel1 name1 contains in excel2 name column if yes need to increase the age+1

if we tried two for each for excel1 and excel2 its taking more time,
so please let me know if there is any alternative for this.

Thank you!!!