Datatable return a row item value if column equals something

datatable

#1

Say, for example, I have the following datatable called “CallerData” that was scraped from a site:

ID,Caller,Rating
0013,Peter,1.5
2313,John,2.2
3412,Joseph,1.5

How do I get the the “Rating” value if the ID = 2313?
Also, how do I get the row int value if the ID = 2313?

I’ve been stuck trying datatable.select, etc. Please help.


#2

Hi @Brian_RPA_Dev,

Convert.Tostring(CallerData.Select("Rating='2313'")(0)("ID"))

Regards,
Arivu


#3

Wonderful! It worked liked a charm. Thank you so much @arivu96 :grinning:


#4

One note: I think it should it be:

Convert.Tostring(CallerData.Select(“ID=‘2313’”)(0)(“Rating”))

instead. Otherwise, I got the idea and was able to apply it to my project.


#5

Hi @Brian_RPA_Dev,

Refer this post for more datatable operations

Regards,
Arivu