How to Remove the last record using sender SFTP adapter

[former_member441596]

Hi ,

Can please help me,how to remove the last record from file using sender SFTP adapter.

Please see below my requirement and highlighted last record want to be removed.

D|101|20150916|20150916|5000429256|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429257|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429258|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429259|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429260|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429261|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429262|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429263|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429264|0001|1000|000000000001960006|

D|101|20150916|20150916|5000429265|0001|1000|000000000001960006|

T|0000000010|1609201500||||||||||          2155.000|

Thanks & Regards,

Naidu

[former_member441596]

Thanks Guys,

My issue was resolved.

[former_member441596]

Hi ,

How to handle this method in mapping ?give an example.

[former_member186851]

Hello Varri,

Use createif the node value equals to 'D' or use create if then not if the condition is equal to "T"

[vishnu_pallamreddy]

Hi VARRI,

Please go through the below link:

how to ignore the last line in a file using FCC... | SCN

[azharshaikh]

Hi Naidu,

AFAIK there is no standard option to remove the last line in FCC.

I suggest you do FCC config for last line as well and ignore the record in Mapping level.

Regards,

Azhar

[former_member186851]

Hello Azhar,

Best way is to ignore the record in the mapping.

Or try this

Structure.keepIncompleteFields = YES

Structure.missingLastfields = ignore

[former_member441596]

HI Azar,

How to handle this method in mapping?Given an example.