Generate Multiple Files without outputting key column value
Posted: Tue Dec 10, 2013 6:31 am
I am creating multiple files through one sequential file stage using the "Generate Multiple Files" option.
The filename is based on a root file string plus the value of a key column, so that for each distinct value of the key column a new file is generated containing the key value in the file name.
For the output properties I have set:
- Write Method = Generate Multiple Files
- Exclude Partition String = True
- Key = <fieldname>
- Use Value in Filename=True
- Root File String = <base file name>
That works perfectly fine. However it forces me to include the key column in the output, and I do not want to include that in the output. I only want to use it to set the filenames of the output file.
Is there any way I can achieve that? (using the generate multiple files property)
The filename is based on a root file string plus the value of a key column, so that for each distinct value of the key column a new file is generated containing the key value in the file name.
For the output properties I have set:
- Write Method = Generate Multiple Files
- Exclude Partition String = True
- Key = <fieldname>
- Use Value in Filename=True
- Root File String = <base file name>
That works perfectly fine. However it forces me to include the key column in the output, and I do not want to include that in the output. I only want to use it to set the filenames of the output file.
Is there any way I can achieve that? (using the generate multiple files property)