Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

File Content Conversion for a CSV file with Field names in the first row.

Hi Geeks,

I need to pick a csv file which has the field names in the first row. But the data starts from line 2.

The file looks as follows

Shipment Date,Airline Carrier Code (DHL),Mode,Airline Carrier Number,Freight Airway Bill Number,Origin,Destination,Service Center,Weight,Weigt Unit of Measure,Pieces,Total Value

8/5/2007,AS,D,27,12345678,JFK,SEA,JFK,1234567.12,LB,10,1234567.21

I am getting the payload as below.

- <ns:MT_CAL_DW_MULTI xmlns:ns="http://PurchOrder">

- <CAL_PO>

<shipment_date>Shipment Date</shipment_date>

<airline_carrier_code>Airline Carrier Code (DHL)</airline_carrier_code>

<mode>Mode</mode>

<airline_carrier_number>Airline Carrier Number</airline_carrier_number>

<freight_airway_billnumber>Freight Airway Bill Number</freight_airway_billnumber>

<origin>Origin</origin>

<destination>Destination</destination>

<service_center>Service Center</service_center>

<weight>Weight</weight>

<weight_unit_of_messure>Weigt Unit of Measure</weight_unit_of_messure>

<pieces>Pieces</pieces>

<total_value>Total Value</total_value>

</CAL_PO>

- <CAL_PO>

<shipment_date>8/5/2007</shipment_date>

<airline_carrier_code>AS</airline_carrier_code>

<mode>D</mode>

<airline_carrier_number>27</airline_carrier_number>

<freight_airway_billnumber>12345678</freight_airway_billnumber>

<origin>JFK</origin>

<destination>SEA</destination>

<service_center>JFK</service_center>

<weight>1234567.12</weight>

<weight_unit_of_messure>LB</weight_unit_of_messure>

<pieces>10</pieces>

<total_value>1234567.21</total_value>

</CAL_PO>

</ns:MT_CAL_DW_MULTI>

Here the requirement is that the communication channel should ignore the first row which contains the field names and should start reading from line 2.

It would be a great help if some body can throw light that how this can be achieved.

Thanks,

Noorul

Former Member
Former Member replied

Hi Noorul,

In Sender Communication of File Adapter, set the value for Document Offset as 1.It means the first record of the file has not been come into payload.Check this it will solve u r problem.

Cheers

Veera

>>> Reward points, if it is needful.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question