Hi,
And what exactly is your problem? As long as the list of companies is always in the same order, it should not be a problem to use the csv as data connector and simply enumerate all its rows and compare each row with appropriate TD tag in table? The only problem is, that there is currently no way to associate Company and Value header with appropriated TD cell, using an elegant one-do-it-all xpath. It's something I've requested a while ago, unfortunately, it got a very little attention from the community, therefore, it scored very low number or votes
https://uservoice.ranorex.com/forums/15 ... -html-cell
You have two options.
A) if you are sure, that the order of columns will remain the same over the time, ou can create an xpath with hardcoded index of TD belonging to Company and Value columns:
Company TD xpath:
/dom[@domain='test.mywebroster.com']//frame[#'frmContents']/?/?/frame[@name='InvoiceContents']//table[#'grdInvoiceLog']/tbody//td[2][@visible='True']
Value TD xpath:
/dom[@domain='test.mywebroster.com']//frame[#'frmContents']/?/?/frame[@name='InvoiceContents']//table[#'grdInvoiceLog']/tbody//td[5][@visible='True']
Now because you want to match "company" and "value" values, you can do something like this:
/dom[@domain='test.mywebroster.com']//frame[#'frmContents']/?/?/frame[@name='InvoiceContents']//table[#'grdInvoiceLog']/tbody//td[2][@innertext='10'][@visible='True']/../td[5][@visible='True']
The above xpath returns "value" TD for company "10". Now you should variabilize the company:
/dom[@domain='test.mywebroster.com']//frame[#'frmContents']/?/?/frame[@name='InvoiceContents']//table[#'grdInvoiceLog']/tbody//td[2][@innertext=$companyName][@visible='True']/../td[5][@visible='True']
So now if you connect the
companyName variable with customer column in your csv, the test should cycle through the csv, and you can validate inner text of each returned TD element (by above xpath) with Invoice Value obtained from CSV file.
The problem of above solution is, that if the order of columns changes, you may need to manually update the TD indexes in above xpath. Hence it's better get the actual childindex of Customer and Value column via GetValue action, as described here:
https://www.ranorex.com/forum/slicing-t ... tml#p52064
B) A completely different approach could be using table snapshot and some code, as described here:
https://www.ranorex.com/help/latest/han ... einwebibri
