Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

.

Consider that the original file contains only a few records (as demonstrated being created in a CSV Generator Snap, but can be read from a File Reader with a CSV Parser).

Image Modified

By comparison, the new file has over 1000 records (again, demonstrated being created in a CSV Generator Snap).

Image Modified

Because the comparison can only be done by sorted stream, each file will need to be sorted by the same column, such as $Last, with the same sort order, so add a Sort Snap after each file input (CSV Generators in this example).

Next, configure the Diff Snap with the Sort path and Sort order

This results in deleted lines routing to the Deletions view, new lines to the Insertions view, modified lines to the Modified view, and unchanged lines to the Unmodified view

 

 

Reading an Original CSV File and a Modified Version

...

Info
  1. Download and import the Pipeline into SnapLogic.

  2. Configure Snap accounts, as applicable.

  3. Provide Pipeline parameters, as applicable.

...

Snap Pack History