Hello,
I want to compare two csv files expected.csv and actual.csv by fields "f3", "f4", "f5". Field "z" can be differnt.
Each record identified by two fields: "number" +"key".
Records are not sorted.
Can you please help me to get such report:
Error: Mismatch in the record "1,a,33,44,56,333", field "f5". Expected - 56, actual - 55
Error: There is no record "4,d,90,12,56,888" in Expected
Error: There is no record "4,x,90,12,56,333" in Actual
expected.csv:
number,key,f3,f4,f5,z
1,a,33,44,56,333
1,b,45,56,67,222
2,c,55,56,89,222
3,d,87,88,90,444
4,x,90,12,56,333
actual.csv :
number,key,f3,f4,f5,z
1,a,33,44,55,999
4,d,90,12,56,888
1,b,45,56,67,777
3,d,87,88,90,777
2,c,55,56,89,777
Thanks in advance