cancel
Showing results for 
Search instead for 
Did you mean: 

Ignore header line in message mapping

0 Kudos

Hello,

I am using a sender SFTP adapter and I want to ignore the first row (header line). As I have read, there is no opportunity for a sender SFTP adapter to use xml.documentOffset or xml.documentSkipFirstRows or something like that in the MessageTransformBean. So I have to do it in the message mapping.

Actually the mapping looks like this:

So if the first field contains "MerchantTransactionID" the line should be ignored, otherwise a target row should be creaded.

But when I test it there is nothing being created...

I have tried a few things, but I don´t get it. What is wrong?

Regards,

Marcus

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello,

Did u tried using below parameters to skip rows?

xml.processFieldNames ------------ from File

xml.documentsSkipFirstRows-----   1

Check Rene's reply:

Regarding MessageTransformBean

Thanks

Amit Srivastava

0 Kudos

Hi Amit,

indeed, it works!

I didn´t expect an answer like this, but this is the nicest way to solve it.

Thank you!

Former Member
0 Kudos

Glad to know that i surprise u

Answers (1)

Answers (1)

former_member191435
Contributor
0 Kudos

Hi,

Please change the context of  "MerchantTransactionID" filed to ROW level. It should work...

Other option is what Amit sugested...

Thanks,

Sreenivas