Using Excel Sheet for Data Driven Loop with Empty Cells
I am really new to using Test Complete and I have created a data loop using Excel to iterate through a bunch of rows of data. It works fine except for when the field in the excel sheet is empty which in some cases it will be empty for the street prefix of an address. The problem is the test fails when it hits the field in the Excel sheet that is empty for the street prefix. I have looked around in the help and played with the data set but have not been able to find a way for the loop to just enter nothing if the field in Excel is empty and then move on to the next field. Any help would be greatly appreciated.