I want to achieve a simple use case to update the multiple string/Text values to an Integer value in a field inside a CSV using NiFi. For Example, my CSV file looks like: Input CSV File: Field_1, Field_2 America, Apple…
I have a flow GetFile->ConvertRecord->splittext->PutdatabaseRecord. My csv file I am sending in to the GetFile contains followings fields: ID TIME M00B01 M00B02 M00B03 1 2018-09-27 10:44:23.972 3242 35 335 2 2018-09-21 11:44:23.972 323 24 978 MY database table skeleton in…
I want to extract few fields along with its value from a CSV file and drop/delete all other fields in the file. Please help. I think we can use RoutText processor.Please tell me how to write the regular expression for…