Skip to Content
avatar image
Former Member

Splitting File in Source by using SFTP Sender adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 07, 2017 at 04:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2017 at 08:57 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2017 at 11:26 AM

    Hi Shivram,

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

    Thanks,

    Sonalika

    Add comment
    10|10000 characters needed characters exceeded