column Question

[brittonalmy]

I have a file with multiple columns and I would like to split it into multiple files after every fifth column.

Any help is appreaciated.

[DataMystic Support]

You will need to do this in multiple steps, with the Filters\Remove\Columns to remove a different set of unwanted columns each time.

[brittonalmy]

I understand the overall process of splitting the columns, I am having difficulty export the columns I split to a new file. Any suggestions.

[DataMystic Support]

File A goes to a different output file each time - just change the Output Filter setting to direct output to a new file.

This process can be automated from a JScript script - see File Menu\Export for the options.