FindRowInTable
Use this to find a row in a table given an array (table name as string, column name and column value as arrays).
The following example finds the row (“R”) in the ZoneMonth output table where Name=”ERCOT-Houston” and Report_Month=”1”. Note that this command returns a value of -1 if the row does not exist in the specified table. The arrays needed to find the desired row may require different dimensions and can be as large as needed.
Dim colname() as String
Dim colvalue() as String
ReDim colname(0 To 1)
ReDim colvalue(0 To 1)
colname(0) = “Name”
colname(1) = “Report_Month”
colvalue(0) = “ERCOT-Houston”
colvalue(1) = “1”
R=AURORADATASET.FindRowInTable(“ZoneMonth”,colname(),colvalue())
Scripting
FindRowInTable
