Nifi > help me compress a file of 80 MB which is to be send over the mail.   Hi All      I have a urgent requirement to send a file over mail but file size is too   large , i have used mergecontent/Compresscontent but was not able to send the file as putemail is displaying error   can you tell me how to proceed with the same or if there is any other processor do let me know.   @Shu_ashu : please help!! ... View more

Hi All,   I have an urgent requirement.  Suppose i have two csvs: one csv - a,b,c,d second csv - e,f,g,h   I want to merge both csv so as to get one csv with output as a,b,c,d,e,f,g,h.   Both the csvs are getting generated from sql via executesqlrecord processor. Request to help as soon as possible. ... View more

Hi All,   I want to extract records based on certain value in Json file and than send mail separately based on records set.   Can some please help how to do the same and extract record. I have to extract record based on alphabetical values. ... View more

Hi All,   I want to insert csv data (which is getting generated from executsql) to database table. csv header are same as that of columns in table:   TIME timestamp, CAUSE varchar(200) NOT NULL, CATEGORY varchar(100), PREVIOUSCOUNT numeric(11,0), CURRENTCOUNT numeric(11,0), AVERAGE numeric(11,3), SEVERITY varchar(30)   My current flow is like :   Executesql > updateattribute > validatecsv > updateattribute > putdatabase   I am using avroschemaregistry and putting data as: { "type":"record", "name":"TestRecord", "fields":[ { "name":"TIME", "type":{"type":"long","logicalType":"timestamp-millis"} }, { "name":"CAUSE", "type":"string" }, { "name":"CATEGORY", "type":"string" }, { "name":"PREVIOUSCOUNT", "type":"float" }, { "name":"CURRENTCOUNT", "type":"float" }, , { "name":"AVERAGE", "type":"float" }, , { "name":"SEVERITY", "type":"string" } ] }       Please help  as i am stuck , i tried everything making translate field name to true and false both, but getting the same error.   Looking for quick response.    ... View more

Hi All,   I am preparing a flow to insert the records from csv file to database. Following processors used by me are attached hereby.   Also it is: Executesqlrecord > Update Attribute > ValidateCSV > PutDatabaserecord.     I am unable to proceed with the same please guide I want to have database entry from generated csv.   I have same structure of table as CSV column name. TIME CAUSE CATEGORY PREVIOUS_COUNT CURRENT_COUNT 5_MIN_RATIO AVERAGE STDDEV COEFFICIENT SEVERITY ... View more