Skip to Content
0

Splitting File in Source by using SFTP Sender adapter

Mar 07, 2017 at 02:40 PM

64

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Sriprasad Shivaram Bhat Mar 07, 2017 at 04:20 PM
0

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


Share
10 |10000 characters needed characters left characters exceeded
Sonalika Shekh Mar 08, 2017 at 08:57 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Sonalika Shekh Mar 08, 2017 at 11:26 AM
0

Hi Shivram,

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

Thanks,

Sonalika

Share
10 |10000 characters needed characters left characters exceeded