Add a processor in between and remove the entries you don't need. Best, Christian
Christian ----------------- Software Integration Specialist Apache Member V.P. Apache Camel | Apache Camel PMC Member | Apache Camel committer Apache Incubator PMC Member https://www.linkedin.com/pub/christian-mueller/11/551/642 On Wed, Apr 29, 2015 at 11:36 AM, imranrazakhan <[email protected]> wrote: > 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. >
