Navigation: How do I? >
Split a dataset into multiple files
Easy Data Transform supports splitting datasets into multiple files in 2 different ways.
To split a dataset according to whether the Gender column contains M or F, use a pair of Filter transforms.
To split a dataset according to Region column values:
•Use transforms (such as Substitute) to create a column with the file location you want to output to, based on the Region column. The location can be an absolute path (e.g. c:\users\andy\output.csv) or a path relative to the .transform file location (e.g. results\output.csv). Folders output to must already exist. Empty or invalid values are ignored. This column is not output (use the Copy Cols transform if you want it to be).
•Create an output with Output to set to Multiple files and the Files column selected.
•Set Confirm files checked to be prompted before writing (recommended).
To split a dataset into files of 1000 rows each: