SAP BODS 3.1 csv delimiter issue
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.
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.
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