csv-compare
csv-compare copied to clipboard
Missing variables are not always skipped
CSV Compare does not skip variables which aren't present in both csv files in some cases. For example the following base.csv:
time;a;b;c
0;1;2;3
1;2;3;4
2;3;4;5
3;4;5;6
4;5;6;7
and actual.csv:
time;a;x;c
0;1;0;3
1;2;0;4
2;3;0;5
3;4;0;6
4;5;0;7
Note that b exists in base.csv but not in actual.csv, and x is missing from base.csv but exists in actual.csv. In the generated report the variable b is listed with a 100% success rate. This is a rather severe bug since the user get the impression that everything is fine and the variable produces the correct result! It does however leave a warning in the log, saying that b has been skipped (which it apparently haven't). Log:
2015-07-07Z13:16:51 [ Warning ] b not found in "actual.csv", skipping checks.
Command used:
Compare.exe actual.csv base.csv -r out
Version:
CSV File Comparison Tool v2.0.0-rel
Copyright ? 2015 ITI GmbH