Datatable return a row item value if column equals something

Help
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