About dobariyas

dobariyas · ‎10-25-2018

@Shu Though it did not work with this one and flow file going to failure relationship without modification. It's alright as I get it worked with Convert Record. Thanks for help. May I know Is there any way to avoid change of header in CSV and We can map CSV header to database table column directly similar to any ETL tool?

dobariyas · ‎10-24-2018

Hi Shu, Let me thank you for your quick response and it is really helpful. I have tried both way and it worked using ConvertRecord and ReplaceText. May I know the reason why it is not working using just ReplaceText with huge file? My CSV file contains >60K reocrds. I was using below ReplaceText configs as you advised but it is getting failed. Search Value (.*) Replacement Value ${'$1':replace(" ","")}

dobariyas · ‎10-23-2018

This is my dataflow - Getfile (CSV) -> PutSQL (To truncate the database table in MS SQL) -> PutDatabaseRecord (To Insert record in the table) -> LogAttributes upon success or failure I have following header row in CSV file. Date Location Name Manager Division Revenue PV NMS OnLine NMS LHSC RMS OnLine RMS LHSC I want to change the name of the last four column From NMS OnLine NMS LHSC RMS OnLine RMS LHSC To NMSOnLine NMSLHSC RMSOnLine RMSLHSC as Original name is not matching to table column name in database. I am trying to use ReplaceTextProcessor but it is not working. How do I achieve this? @Shu

dobariyas · ‎10-23-2018

Hi Adil, Can you provide complete details with configuration for the data flow you implemented? It will be great help. Thanks, Sandip

Online	Offline
Last Visited	‎10-26-2018 04:42 PM

Member Since	‎10-23-2018 03:22 PM
Last Visited	‎10-26-2018 04:42 PM
Posts	4

Cloudera Community

Re: How can I change specific column title in CSV ...

Re: How can I change specific column title in CSV ...

How can I change specific column title in CSV file...

Re: Nifi - Truncate and Load to mysql db table