Review a launch checklist
2 added lines, 1 removed line and 4 matched lines. The status edit is a removal plus an addition.
Small fictional datasets, explicit settings and expected outputs. Open a prepared case or download the files to run it yourself.
2 added lines, 1 removed line and 4 matched lines. The status edit is a removal plus an addition.
With sku as the key: 1 changed row, 1 added row, 1 removed row and 1 unchanged row.
The postal code stays "00123", paid stays true, and the order remains a JSON object.
2 records. Postal codes stay strings; a comma and a line break stay inside their notes cells.
yes stays a string, true becomes a boolean, and null remains distinct from empty text.
3 differences: status changed, note removed and tracking added. Moving object keys adds no changes.
4 data rows become 2 after trimming, blank-row removal and exact deduplication.
5 input lines become 3. First-seen order and the uppercase SALES address are preserved.
Start with unchanged inputs and settings. Compare your result with the supplied output, then change one field or option at a time. A successful example shows how this tool behaves; it does not validate your own application’s business rules.