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