Micro Focus QTP (UFT) Forums
data from row column intersection - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: data from row column intersection (/Thread-data-from-row-column-intersection)

data from row column intersection - chetan.dewangan - 03-04-2008

My que is:
If I want to fetch value from datasheet based on particular column-row intersection (like where clause in database).
Like I have value in two column as follows:
Gujarat-Gandhinagar
Maharastra-Mumbai
Karnatka-Bangaore

If I want to fetch Capital based on State, like from the data base:
Select Capital from tble where state="Karnatka"

Is it possible from datasheet, if yes how?

RE: data from row column intersection - sreekanth - 03-04-2008

you can use

Code:
DataTable.SetCurrentRow(RowNumber)'this will set the row
and

Code:
DataTable.Value(ParameterID [, SheetID])

or

Code:
DataTable(ParameterID [, SheetID])
to retrieve the value from a specified row and column