+- 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: VB Scripting/Descriptive Programming (https://www.learnqtp.com/forums/Forum-VB-Scripting-Descriptive-Programming)
+--- Thread: How to compare local sheet values with run time data table values? (/Thread-How-to-compare-local-sheet-values-with-run-time-data-table-values)
How to compare local sheet values with run time data table values? - test71 - 03-10-2008
Please,Can anyone tell me how can I compare local sheet data with the value in run time data table?
RE: How to compare local sheet values with run time data table values? - sreekanth chilam - 03-11-2008
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 ifRE: How to compare local sheet values with run time data table values? - test71 - 03-14-2008
Thanx alot Sreekanth...I was able to execute the above script successfully ang get the expected output.