How to process a .csv file without header

[Former Member]

Hi Experts,

Is it possible to process a .csv file using FCC which contains 14 columns & 'n' number of rows which does not contain the header information.

Please let me know the possibility.

Thanks in advance.

Nag

[santosh_k3]

Hi Nagendar,

As Grzegorz mentioned , yes we can process .csv without header data.

Suppose your source file has

abc,xyz...ABC

123,456...999

For example consider your source structure as

<Name>

<Field1>abc</Field1>

<Field2>xyz</Field2>

.

.

<Field14>ABC</Field14>

</Name>

<Name>

<Field1>123</Field1>

<Field2>456</Field2>

.

.

<Field14>999</Field14>

</Name>

Then in FCC pass:

Recordset Structure : Name,*

Name.fieldNames = Field1, Field2, ..., Field14

Name.fieldSeparator = ,

Name.endSeparator = 'nl'

If the .csv file consists of header information and you do not want to process header data

then in FCC pass :

Document Offset : 1

I hope this would solve your question.

Thanks

Sai

[former_member184681]

Hi Nag,

If all your lines have identical structure, then the answer is: yes. Simply type Recordset Structure as Name,*, and the required set of parameters below, for instance Name.fieldNames = Field1, Field2, ..., Field14 and so on. Refer here for more details on FCC parameters: http://help.sap.com/saphelp_nwpi71/helpdata/en/44/6713ec3f914ddee10000000a1553f7/content.htm

Hope this helps,
Greg