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

To report this post you need to login first.

1 Comment

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

Leave a Reply