hi all,
I have a requirement to split a DBF file based on the values in one column, into a number of output files.
One output file for each split value.
So, if the input column has the following values: A, B, C, D the job should create 4 files named A.DBF, B.DBF, C.DBF, D.DBF each filled with the correctly splitted records.
Can I use the switch stage for this?
How to handle the fact that I don't know the number of output files in advance.
Peter
split records to multiple output files
Moderators: chulett, rschirm, roy
One approach would be, count the number of records (can be using link row count) and pass it as a variable into Loop activity, for each loop read the corresponding line of the file and pass the value as parameter to a job to create a file using that job parameter value.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
In server jobs we can use a folder stage
Hi,
In Server Job I used a folder stage to do this logic. In a folder stage give your input column as the filename and the other columns concatenated give it to Record field of the Folder stage. This will create multiple files.
In Server Job I used a folder stage to do this logic. In a folder stage give your input column as the filename and the other columns concatenated give it to Record field of the Folder stage. This will create multiple files.