Splitting File in Source by using SFTP Sender adapter

[Former Member]

Hello,

We have a requirement according to which we need to split the Source File into smaller Files(100 records at a time) and put it in the Archive Folder in Source using SFTP sender in HCI.Please suggest.

Thanks,

Sonalika

[Former Member]

Hi Shivram,

Just adding one more point here.. I think we can achieve it by Iterative Splitter, not by General Splitter.

Thanks,

Sonalika

[MIB]

Good input. Just used the Iterative Splitter to split a CSV file, and the difference between Iterative Splitter and General Splitter, is the the Iterative Splitter does not add the header liner on each splittet file.

[Former Member]

Thanks Shivram for the response...I will go with this approach..

[Sriprasadsbhat]

Hello Sonalika,

Its not possible to split the file at sender adapter level before moving to archive directory.As an alternative you can follow below approach.

I have assumed you have CSV file and you can split it using General Splitter ( if you want to keep the header )

Input File:

Output:

Got 3 output file to archive location with data 11 rows [ 1 Header + 10 Rows ] ,11 rows [ 1 Header + 10 Rows ] and 3 rows[ 1 Header + 2 Rows ] respectively.

Integration Design:

Regards,

Sriprasad Shivaram Bhat