XSMeXtended Sort Merge

Demo overview

Sort, merge and deduplicate CSV files in nine steps

This illustrated demonstration starts with a CSV input file, builds the XSM parameters and progressively introduces headers, multiple inputs, duplicate removal, selective filters and file-name variables.

1. Overview of the input file
2. The XSM parameter file: contains the XSM sort directives, options, and input and output file names
3. Run XSM
4. Remove headers  SKIP_HEADER
5. Merge multiple files  INPFIL, SKIP_HEADERS
6. Deduplicate records  OMIT DUPLICATE RECORDS
7. Split data with selective filters  INCLUDE / EXCLUDE
8. Use variables for file names  DD:
9. Now it is your turn

Start the demo