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
That is correct. For the loop, it will show you the column names in the drop down. You will be looping through all rows in the EXCEL sheet so you're going to be comparing the contents of the desired column with the desired value. So, since you're looking for the LONGNAME value, select that column in your table data. Then, in the Value 2, enter the string 'XYZ'. If you're looking for it to be equal, then use the condition of "Equals". This will compare the contents of that column with the string over all records in the loop. When the condition is met, whatever you make a child of the if..then will execute.
