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.