System only loading the first column from csv

[Former Member]

Trying to load data from Excel saved as csv, but the preview and PSA shows data loaded only for the first column from the csv file. All other columns are not loaded from the csv. Changed the lengths of the fields from the datasource to match the ones in the csv to 8, but it only seems to load the first column. What could be the cause?

[Former Member · Accepted solution]

Change the file format to ',' or '|' and check it

[Former Member]

Hi,

If your file has headers, put the no of header rows to be ignored in the extraction section of the infopackage as 1.

In file type select CSV .

also try changing the seperator to ',' if it is ';' and then try loading the data .

[Former Member]

Check and make sure that u use comma separator, also ignore rows that are not included in your real data.

[Former Member]

Hi

Check the file format once and general tab in Data source(make sour you selected comma separated file and symbol)

check below link

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/01ed2fe3811a77e10000000a422035/frameset.htm

Regards,

Venkatesh