08-29-2018 02:42 PM
Created by @hkaplan
This pipeline pattern shows how to use SnapLogic’s snap.out.totalCount and the Join Snap to compare current and/or previous incoming records or current and/or next incoming records and set a Control-Break Flag to identify when a Control-Break occurs.
The self-contained data has 2 outputs: one comparing current record with next record and the second comparing current record with previous record.
Sources: JSON Generator; ID, Name, and InvoiceAmount
Targets: Mapper, Input elements with Control-Break Flag
Snaps used: JSON Generator, Mapper, Copy, Join
Control-Break using Join on Next Record Pattern.slp (13.9 KB)