cancel
Showing results for 
Search instead for 
Did you mean: 

Reg MessageTransformBean [SimplePlain2XML] : how to ignore header row

Former Member
0 Kudos

Hi,

I need to ignore first row(header) from the input file. Also I need to use SFTP adapter with MessageTransformBean [SimplePlain2XML] contacining xml.processFieldNames=  fromConfiguration [Because file header has special character in the header].

Please provide your views how to ignore the first row.

Thanks.

Accepted Solutions (0)

Answers (3)

Answers (3)

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Mutharasan,

Try with the below parameters:

Plain2XML     xml.processFieldNames     fromFile

Plain2XML     xml.documentsSkipFirstRows     1

Regards

Former Member
0 Kudos

Hi Vishnu, Thanks for your reply. Header row in input file has special characters, so i need to consider the fieldnames available in configration. so intended here to use 'fromConfig'

pvishnuvardan_reddy
Active Contributor
0 Kudos

Hi Mutharasan,

I think if we use simpleplain2xml conversion type, then the parameters should be

Plain2XML     xml.processFieldNames     fromFile

Plain2XML     xml.documentsSkipFirstRows     1

Else, I am afraid you need to handle in mapping level.

Same issue had been discussed in the below thread:

Regarding MessageTransformBean | SCN

Regards

maheswarareddykonda
Active Contributor
0 Kudos

Hi,

mostly that module will not work at this case , so please try to Ignore header in mapping level itself.

BR,

Maheswarareddy

Former Member
0 Kudos

yes, i need to go for ignoring that record at mapping level, in case if i dont get any other choice

maheswarareddykonda
Active Contributor
0 Kudos

Please try documentOffset as per below screenshot

Former Member
0 Kudos

Thanks for your reply. But i tried it dint work.
Also I referred to doc: http://scn.sap.com/docs/DOC-58321