Skip to Content
0
Jul 28, 2016 at 10:22 AM

How to handle multiple structures in sender file content conversion in SFTP?

1462 Views

Hi,

I have a file structure like below with fixed length.

FileHeader

field1,field2,...

BatchHeader

field1,field2,....

DetailRecord

field1,field2,....

BatchTrailer

field1,field2,....

FileTrailer

field1,field2,....

File Header and File Trailer repeats once in the file. Batch Header, Detail Record and Batch Trailer repeat multiple times. May be take it as for each employee the Batch Header, Detail Record and Batch Trailer gets repeated with multiple line items (Detail Record ) for each employee.

FH0012016 28072016

BH0165757 28072016 1st

DT0165757 28072016 Richa 388893 34.09

DT0265757 28072016 Tina 385693 36.09

BT0165757 28072016 1st

BH0234345 29072016 2nd

DT0134345 28072016 Dilip 388893 44.09

BT0165757 28072016 2nd

FT0012016 28072016

I tried placing the file in NFS location and pick with file adapter , FCC is not working. Kindly help me how to pick the file with this structure from sender location.

Regards,

Suman