Do all the files look like that, or just the first one? If it is just
the first one, then it is likely due to the header row in your CSV
file. You may want to use RouteOnAttribute after SplitText to get rid
of the header row (using fragment.index = 0), or I think you can use
ReplaceText before SplitText to get rid of the header (but it might
take longer).
If all the files look like that, then the ExtractText is not putting
the right values into the corresponding attributes.
Regards,
Matt
On Wed, May 3, 2017 at 10:20 AM, suman....@cuddle.ai
<suman....@cuddle.ai> wrote:
> Still not able to insert the data in table.
>
> I tested with PutFile instead of PutSql and file contains
> INSERT INTO CITY(city,count) VALUES('city',count)
>
>
>
> --
> View this message in context:
> http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610p15634.html
> Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.
