Iterate over DataSets & DataRecords
dataSet = new DataSet();
myDataRecord = new DataRecord();
if (session.getVariable("A") != null && session.getVariable("A") != "")
{
myDataRecord.put("A",session.getVariable("A"));
}
if (session.getVariable("B") != null && session.getVariable("B") != "")
{
myDataRecord.put("B",session.getVariable("B"));
}
if (session.getVariable("C") != null && session.getVariable("C") != "")
{
myDataRecord.put("C",session.getVariable("C"));
}
dataSet.addDataRecord( myDataRecord );
session.log("how many fields in myDataRecord? " + myDataRecord.size());
int totalValues = 0;
for (int i=0; i<dataSet.getNumDataRecords(); i++)
{
dr = dataSet.getDataRecord(i);
enumeration = dr.keys();
while (enumeration.hasMoreElements())
{
key = enumeration.nextElement();
value = dr.get(key);
session.log("key:value **" + key + ":" + value + "**");
totalValues += Integer.parseInt(value).intValue();
}
}
session.log("Sum of all values for this dataRecord: " + totalValues);
session.log("Average of the sum of all values: " + (totalValues / dr.size()));
// Remove all DataRecord objects from the dataSet object.
dataSet.clearDataRecords();
myDataRecord = new DataRecord();
if (session.getVariable("A") != null && session.getVariable("A") != "")
{
myDataRecord.put("A",session.getVariable("A"));
}
if (session.getVariable("B") != null && session.getVariable("B") != "")
{
myDataRecord.put("B",session.getVariable("B"));
}
if (session.getVariable("C") != null && session.getVariable("C") != "")
{
myDataRecord.put("C",session.getVariable("C"));
}
dataSet.addDataRecord( myDataRecord );
session.log("how many fields in myDataRecord? " + myDataRecord.size());
int totalValues = 0;
for (int i=0; i<dataSet.getNumDataRecords(); i++)
{
dr = dataSet.getDataRecord(i);
enumeration = dr.keys();
while (enumeration.hasMoreElements())
{
key = enumeration.nextElement();
value = dr.get(key);
session.log("key:value **" + key + ":" + value + "**");
totalValues += Integer.parseInt(value).intValue();
}
}
session.log("Sum of all values for this dataRecord: " + totalValues);
session.log("Average of the sum of all values: " + (totalValues / dr.size()));
// Remove all DataRecord objects from the dataSet object.
dataSet.clearDataRecords();
scraper on 07/16/2010 at 5:07 pm
- Printer-friendly version
- Login or register to post comments