When i compare txt type files, everything works well with the DIFF snap but when i try to compare excel files, sometimes the column formats look different and it appears as a MODIFIED row on the repo...
Good day, had a similar scenario before...as a resolution I decoupled the pipeline then in the child pipeline set the all snaps "when error occurs" to "Stop Pipeline Execution" in this way any error that will occur in that child pipeline all on-going process will be aborted thus failing the pipeline then error will bubble-up to the parent pipeline from the pipeline execute ( if possible the child pipeline is reusable ) you can then trap/log the error
The refactored pipeline will be looking something like this ... Parent/Main pipeline