Hi,

I am doing batch insertion into db from CSV file like

        from("file:mycsv")            
        .unmarshal().csv()    
       .to("sql:insert into mytable (value1, value2) Values (#,
#)?batch=true") 
       .end();      

It works fine if CSV columns and Table columns are same, but my CSV has 10
column and Table has 7.

Is there any way to skip last 3 columns from CSV before insertion?

I can use bindy component but i am looking for option in CSV

Regards,



--
View this message in context: 
http://camel.465427.n5.nabble.com/CSV-and-SQL-Component-for-Batch-Processing-tp5766475.html
Sent from the Camel - Users mailing list archive at Nabble.com.

Reply via email to