I'm running NiFi 1.10
My requirement is to read csv data and translate one of the csv column data into csv. What's the best way?
@sandeep1 There are a few ways to handle this. Generally speaking you need to pick up the file, parse the file, transform the file, and send it on. Part of the fun with NiFi is completing this task. My recommendation is to start with some known CSV examples. Get them working, then adjust them for your scenario.
If you reply with a sample of your CSV, and more clear idea of what you are doing I can provide a better example or a template. How are you going to get the CSV into NiFi?
Also your post subject, and the body conflicts: Do you want to do csv to lower case OR parse a column to get a different csv?
I'm getting csv file by GetFile processor and then passing onto next processor to convertCSVtoAvro.
Before converting to Avro format I've to transform one of the column data to lower case.
CSV Sample below, I need to read this csv and convert "Causes" column data into lower case and other column data to be as is.
|Application Performs the wrong function||Application||06-06-18|
|Performs Right function but Takes too Long||Application||06-06-18|
|Mis-matched Sequencing During Application execution||Application||06-06-18|
|Middle ware failure with no Acknowledgment||WebServer||06-06-18|
|Third Party Application or License error||Other||06-06-18|
I was able to do it with a issue.
I used UpdateRecord Processor
In Properties added -
This converts values to Lower but it creates an additional header line