Question

How to compare two columns of a source file which are merged into single column in Target file using TOSCA Row by Row comparison?

  • 21 November 2023
  • 0 replies
  • 11 views

While doing row by row comparison of two excel files we have below issue 

Example→

Source file “ExcelA” has two columns named “ColA” &”ColB” which contains data in them.

ExcelA

ColA ColB
Air India
Eastern India

Target file “ExcelB” has single column named “ColAB” which contains the merged data of both columns “ColA” &”ColB” of file “ExcelA”

ExcelB

ColAB
Air - India
Eastern - India

Requirement → By using TOSCA “Row by Row Comparision” we need to verify the above two mentioned excels data.


0 replies

Be the first to reply!

Reply