HH&S product

XSMeXtended Sort Merge

Step-by-step CSV sort, merge and deduplication demonstration.

Step 7

Split data with selective filters

Add an INCLUDE or EXCLUDE filter to selected output files.

In this example, New York customers are separated from all other customers. clients1.new-york-only.sorted.csv contains the 46 records whose field 9 equals NY. The complementary file contains 500 − 46 = 454 records.

XSM CSV demonstration — step 7
Step 7 — Split data with selective filters.