Your original example has 5 rows, a header and 4 value rows. Did you remove the header row for your current testing? If not, and you use a Header Line Count of 1, then each flow file probably has two lines in it, the header and the value row, and ReplaceText is probably matching the header lines and thus using the hardcoded "values" of City and Count. Instead you may want a Header Line Count of zero and route/remove the header row from the rest of the value row flow files.
Regards, Matt On Wed, May 3, 2017 at 10:42 AM, suman....@cuddle.ai <suman....@cuddle.ai> wrote: > I am just testing currently with a sample file containing only 4 rows. > > > > -- > View this message in context: > http://apache-nifi-developer-list.39713.n7.nabble.com/Not-able-to-ingest-the-csv-data-to-RDBS-Database-tp15610p15637.html > Sent from the Apache NiFi Developer List mailing list archive at Nabble.com.