Skip to Content
Author's profile photo Suresh S Nadar

SAP BODS 3.1 csv delimiter issue

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:

1,Raghu,sales,mum,india,,

2,,Ram,sales,Bangalore,india,,,,

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.

Thanks

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gokul Gawande
      Gokul Gawande

      Hello Suresh,

      I would suggest that you set 'Adaptable Schema - Yes' in the file format option.

      Note:- For future reference, Any questions related to BODS Please place your question under Data Services and Data Quality. So you'll get answered.

      Regards,

      Gokul

      Author's profile photo Joseph Frament
      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