To export data into multiple CSV files, I would create a Scheduler job that queries Virtual DataPort based where condition and then exports it to a CSV file by doing this we can split up data and store data into CSV file.
For example, I have a bv_student base view in Virtual DataPort, I need to export the data based on department CSE and IT, need to store in the two different CSV files. To achieve that, I would either create two VDP jobs or modify the existing job where condition in the query similar as below,
Initially create a VDP job in Scheduler and then configuring an Extractor below query, and writing it to a CSV requires an Exporter.
`select * from bv_student where department='CSE'`
After executing the job with the above query, then modify the where condition as department='IT' and then execute the job again. By doing this, I was able to get the data in the two different CSV files.
If you have more questions and a user with a valid support access account,then I would suggest you raise a support case in the [Denodo Support Site](https://support.denodo.com/) with more detailed information.
Hope this helps!