Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
sureshs_nadar
Explorer
0 Kudos

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

2 Comments
Labels in this area