How to compare local sheet values with run time data table values?

[test71]

Please,Can anyone tell me how can I compare local sheet data with the value in run time data table?

[sreekanth chilam]

Hi ,

Just check with the below :

Step1. Intially read the values from local sheet...(Local_val=datatable("colname",dtLocalSheet)

step2. Read the values from runtime datatable ..(runtime_val=datatable("colname",dtGlobalSheet)
(note:here runtime datatable is nothing but a trial/duplicate copy of globalsheet)

step3. Validate the step1 & step2 and then display the results

Code:

if (trim(Local_val)=trim(runtime_val)) then msgbox "Validation success" reporter.reportevent 0,"values comparison","validation is passed" else msgbox "validation unsuccessfull" reporter.reportevent 1,"values comparison","validation is failed" end if

[test71]

Thanx alot Sreekanth...I was able to execute the above script successfully ang get the expected output.