keyFieldValue in Sender File Adapter Not Working

[Former Member]

Hi,

I have a flat file like this...

1Field1Field2Filed3.....

2Field1Field2Field3....

1Field1Field2Filed3.....

2Field1Field2Field3.....

1Field1Field2Filed3.....

2Field1Field2Field3....

My requirement is to pick only lines starting with '1'.

I have configured the Sender File Adapter like this,

Recordset Structure : SOURCE,*

Key Field Name: KF

Key Field Type : String(Case-Sensitive)

File Content Conversion:

SOURCE.fieldFixedLengths 1,5,5,5....

SOURCE.fieldNames KF,FIELD1,FIELD2....

SOURCE.keyFieldValue 1

After all this, still it picks up all the recored instead of records starting with '1'. Can any one solve this?

Regards,

Sreedhar

[Former Member]

Sreedhar,

Keyfeild value function is not to pick to and ignore. It is used to distingush between Header and line items. if you want this then u need to wirte moudle processor.

[Former Member]

Hi Sreeram,

Thanks for the Quick response...

Can u tell me How to write Module Processor

Regards,

Sreedhar

[Former Member]

If you feel module processor is bit tough you can use XSLT Mapping which is simple in sloving ur problem.

Check this blog to do a sample example using module processor.

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

To implement the above check this link....

https://websmp201.sap-ag.de/~sapdownload/011000358700003237612005E/HowToCreateAdapterModules.pdf

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e21106cc-0c01-0010-db95-dbf...

http://help.sap.com/saphelp_nw04/helpdata/en/8b/895e407aa4c44ce10000000a1550b0/content.htm

/people/gowtham.kuchipudi2/blog/2006/01/13/stop-creation-of-an-empty-file-from-file-adapter-using-module