I have an excel with multiple columns where i need to compare it with DB result of 1000+ records.
The DB result has only one column - Address
The excel has Address splitted into Addr1, Addr2, City and State. (4 columns). So while comparison can someone help what kind of steps could be used to combine all these data into a single address.
There is one way to concatenate the excel columns into single column and then do the comparison. Is there any other way to do it in the devtest steps or Assertions to concatenate and compare.