Member since
12-29-2019
13
Posts
1
Kudos Received
0
Solutions
09-30-2021
10:56 PM
1 Kudo
Yes Sumita, it worked.
... View more
04-23-2020
11:44 PM
Hi @aakulov I have around 4 csv files which are having 5-8 columns and yes they do have time column in common. I am able to merge csv but in different rows not in same one. Request others to help as well
... View more
04-22-2020
07:29 AM
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
- Tags:
- apache nifi
- NiFi
Labels:
- Labels:
-
Apache NiFi
04-16-2020
04:32 AM
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
Labels:
- Labels:
-
Apache NiFi
01-12-2020
09:53 AM
@stevenmatison: Sure , i got your point. Csv Reader and Putdatabase Config are given below: Sample of content of Flowfile before putdatabase is as below: TIME,CAUSE,CATEGORY,PREVIOUSCOUNT,CURRENTCOUNT,AVERAGE,SEVERITY 2020-01-10 20:10:00,UNABLE TO COMPLY,DIAMETER: Permanent Failure,1172,1150,686,MAJOR 2020-01-10 20:10:00,Unspecified,NAS,15071,15240,13533,MINOR. Thanks for replying.
... View more
01-11-2020
10:01 AM
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
Labels:
- Labels:
-
Apache NiFi
12-31-2019
10:49 PM
Hi Steven, Your solution worked well. but i have a question related to this topic. In Putemail, for the solution you provided i am using content type 'text\html' which is delivering result in table format (in mail body) but i am also attaching csv in my mail. Now this csv is also displaying data with html tag, is it possible to display the data in original form.(only csv format for attachment without html tag).
... View more
12-30-2019
11:39 PM
Thanks Stevenmatison. It worked!!
... View more
12-30-2019
09:19 AM
Thanks for your help but this is not solving my problem as i want the csv record which itself is in comma separated to be displayed in tabular format as in my mail body through PUTMAIL. I want records to be displayed in table format rather than comma separated or tab one. I have comma separated record : Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY SIP: [487] Request Terminated,173,393,1.271676300578034682,Critical and I want like this in mail body: Release Cause Previous Count Current Count Change_Ratio SEVERITY test_data 276 730 1.644927536231884058 Critical Please suggest a suitable method in order to do the same.
... View more
12-30-2019
07:43 AM
Hi, I tried doing the same by replacetext but I am getting the output as: Release Cause,Previous Count,Current Count,Change_Ratio,SEVERITY test_data,276,730,1.644927536231884058,Critical but i want the same output in tabular format: Release Cause Previous Count Current Count Change_Ratio SEVERITY test_data 276 730 1.644927536231884058 Critical Please help for the same.
... View more
12-30-2019
12:08 AM
Hi All,
I have to display the records of csv file over mail body in tabular format using Putmail.
I am extracting records by executing sql which is scheduled at some duration and than forwarding the same using putmail to some specific users.
Can someone please tell me how to display the data of generated csv file in tabular format.
... View more
Labels:
- Labels:
-
Apache NiFi