Regarding Iterative Splitter not working for CSV File

[Former Member]

Hello,

I have a csv file containing 4 records which I want to split into two files each containg two records in SFTP server.I am using iterative splitter,Also receiving two files in STP but first file has two records and 2nd file is coming as blank.

Please suggest

Thanks,

Sonalika

[mandy_krimmel · Accepted solution]

some points/questions:

• As the csv converter always always sets a line break after the last entry the splitter currently creats an empty file as last split. This will be fixed with one of the next releases. So that would probably explain the empty file.
• Concerning the other file: How is file name configured in sftp? Maybe second split overwrites the first file or last split with empty file overwrites the second split. You should check which entries are available in the file and should make sure the file name is not reused, meaning no fixed file name in sftp receiver, also not with timestamp - this ma not be unique if the processing is very fast. You can get the unique name e.g. by setting CamelFileName header to a unique value in Content Modifier before the sftp Call, maybe using a specific value from payload.

[Former Member]

Hello Krimmel,

Thanks for the answer.Yes you are correct my files were overwriting each other.Also the processing time was also fast so adding time stamp was also not working.So I used counter and noe able to get Files correctly.

Thanks again,

Sonalika