1)I have 3 excels with data I need to compare few columns in one excel with other.
2)the column names or index are not constant if will come from config will match the columns based on config nd rename
3) expected output shoulbe like the column present along with column compared with validation result match or unmatched likewise for all the columns to be compared
Ord Id1 ord Id2. OrdStatus Uts1 uts2 unstatus
1. Match. 001. 002. Notmatc
2. Match. 005. 005 match
4. Not match