Sender file adapter - content conversion question

[Former Member]

Hi all

We have a .csv file to be passed to XI that has column headings as well. Is there a way of stripping the header using "Content conversion". We declared the RecordsetStructure as "header,1,item,*" but then it needs a keyFieldname and identifier which is obviously not available as the first line only has column headings.

Hoping for a reply soon.

Thanks

Salil

[Former Member · Accepted solution]

Salil,

In RecordsetStructure you define as header,1,item,9999999999. But if you have more than 9999999999 records then the extra records after this will come as a second file.

If you expect more item records then increase the number of 9's. Then we dont need to give the key field.

---Satish

[Former Member]

Thanks a lot Satish.

It works now.

Regards

Salil