AnsweredAssumed Answered

How to concatenate columns in excel while reading

Question asked by balu_rk on Jan 24, 2018
Latest reply on Jan 31, 2018 by balu_rk

Hi,

 

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.

Outcomes