Skip to Content

HI All,

I have requirement for the below issue facing on SAP BODS XI 3.1

Eg: I have one .csv file for the below format:



separated by comma, and I need to extract only 5 columns in BODS, file format is not proper for comma separated

i.e..,first row contains 7 columns

second row contains 9 columns

While creating file format, by default it’s create maximum columns fields in file format,
after file format, I have created query transform to map only 5 columns.

When I executed the BODS job throwing an error that “A row delimiter was seen for row number <1> while processing column number <7> in file”.

Could you please suggest that, how can I resolve this kind of files in .csv format.

Please help on ASAP.


To report this post you need to login first.


You must be Logged on to comment or reply to a post.

  1. Joseph Frament


    usefull tip for me as well , I had a random trailing column separator ( i..e sometime present sometim not)  setting‘Adaptable Schema –Yes‘ and adding a dummy extra column resolved my issue


Leave a Reply