The following screenshot is the logic you should be running with. The outlined if--then is where you need to add your "Else" clause to report that the requested text is found.
Rather than using the Call Object method for creating the DDT object, there is a Data-Driven Loop operation built into keyword tests under the Test Actions grouping. Generally, it works the same way as the DDT.ExcelDriver.
What you would do is drop that action into your keyword test, specify the parameters for your excel sheet, and then add operations under that loop operator to check the value of the desired column in your spreadsheet against the desired test value. When that value is found, you can log it.
Thanks for the reply.
Can you please advise what operation would I add under that loop operator to check the value of the desired column in the spreadsheet against the desired test value ? And how do I log it ? Thanks
Regards
G
Basically, use an If--then operation to check the value of the data field and compare it to the desired value. if that condition is met, use a Log operation to log the message.
Hi there
Kindly refer to the attached spreadsheet with the screenshots.
Basically I had used Data Driven Loop and had selected excel worksheet (from which I need to validate a cell) as table type. Then I used If....Then as the child operation and where it says specify the condition that the operation will check, I am not sure what should I use in 'Value1', 'Condition' & 'Value2' for it to validate that value or text 'XYZ' exist in column 'LONGNAME'. It is displaying the colum names but not the contents hence I am struggling. Thanks
