Prabhu, My guess is that you probably could find some way to do this with the standard out-of-the-box processors that come with NiFi. Perhaps by using Extract Text to extract the header columns, and then using ReplaceText and perhaps a few other processors. Going down this route though is likely to be incredibly inefficient, though, and hard to understand/maintain.
I think this is a great use case for either a custom processor or a simple Groovy/Python script using the ExecuteScript Processor. Thanks -Mark On Jan 30, 2017, at 1:12 AM, prabhu Mahendran <prabhuu161...@gmail.com<mailto:prabhuu161...@gmail.com>> wrote: I have a CSV data with 100 columns like below.., ,A,B,C,D,E,F,..........[upto 100 Header columns] Date,A1,B1,C1,D1,E1,F1..........[upto 100 Header columns] 30/01/2017 23:23:22,Majestic,32,2100.12....[upto 100 data columns] In data having first 2 header lines and 3 rd line is data in which i inserted with header lines in below format. In Database insert those data with following format. insert into data values('30/01/2017 23:23:22','A','A1','Majestic'); insert into data values('30/01/2017 23:23:22','B','B1,'32'); Please stop me if anything i'm doing wrong. Is this possible in apache nifi? Many thanks
