on 04-04-2012 11:38 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.