how to ignore 1st row form the file(csv) sender CC

[Former Member]

Hi,

I have a CSV File (File sender) that I need to load with PI.I want to Ignore 1st row from the file.

For example the File contains 10 rows but PI need to read the data from 2nd row.

because in the 1st row contains header data like name, number, mobile, address, etc., I don't want to read this 1st row. I want to read only the data which starts from the 2nd row.

can you pls tell me the ignore command File Receiver CC

I am using these commands.

Record structure: item,*

item.fieldSeparator: ,

item.endSeparator : 'nl'

item.fieldNames: Name, Number, Address, Mobile

Thanks in Adv

Vankadoath

[naveen_chichili · Accepted solution]

Hi Vankadoath,

In your content conversion use the field document offset which ignores the number of lines to be ignored.

for example if you provide the value as "1" for document offset it will ignore the first line in your file.

(Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.

This enables you to skip comment lines or column names during processing.

)

Regards,

Naveen.

[Former Member · Accepted solution]

I resolved the issue by adding 1 in the Document Offset. Thanks for the Replies.

Regards

Vankadoath

[Former Member]

Hi,

How can we ignore the first record in a csv file, in SFTP channel.

Do we have Document Offset attribute in SFTP channel as well ?

BR,

Pankaj Walia

[vishnu_pallamreddy]

Hi Pankaj,

Try as per the attached document.

[baskar_gopalakrishnan2]

Yep under Document Offset field set value = 1 if you want one row to be ignored. If you want more than a row specify the number of rows here.

[Former Member]

i have the same scenario in my current interface and as specified above, you just need to put "1" to neglect the 1st row in the "Document Offset" under Content Conversion Parameter in sender file adapter.

http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/content.htm

Regards,

kanan

[Former Member]

Hi,

You have to set "Document Offset" upto the lines which needs to be skipped.

Also refer to the http://help.sap.com/saphelp_nw04/helpdata/en/2c/181077dd7d6b4ea6a8029b20bf7e55/frameset.htm.

Regards,

Vishal K

[Shabarish_Nair]

Under Document Offset, specify the number of lines that are to be ignored at the beginning of the document.

ref: http://help.sap.com/saphelp_nwpi711/helpdata/en/44/6713ec3f914ddee10000000a1553f7/frameset.htm