@Love-Nifi  As @Magudeswaran  mentioned it depends on the concrete processor you are using and the format of the response you are expecting. For example after an ExecuteSQL I check the content this way using RouteOnContent. Check no-content ... View more

@rakz  Did you try your SQL-statement interactive? As far as I know INSERT INTO does not accept WHERE-clause at least not at microsoft sql server. ... View more

@mehdi58  I haven't done this until now myselfe but I don't think that the flowfile-UUID is meant by "provenance event id". At the moment I can't try but maybe this link will be helpful for you: https://community.cloudera.com/t5/Support-Questions/Nifi-how-to-get-provenance-event-id-in-nifi/m-p/154682 and https://community.cloudera.com/t5/Community-Articles/How-to-use-provenance-events-id-nifi-rest-api/ta-p/245440 ... View more

@totti1  I'm sorry, I'm obviously confused.   :-(( Just to correct the csv-output for the solution you don't need (but maybe someone else...) I add this picture: correct csv output format ... View more

@totti1  I can't confirm that ConvertExcelToCSVProcessor processor does not work with xlsx. It works, only thing I haven't achieved until now is to format the csv-output in the right manner.   Maybe this will help you to get it? My test xlsx data:   id title first last 1 miss marlene shaw 2 ms letitia jordan 3 mr todd graham 4 mr seth martinez 5 mr guy mckinney 6 ms anna smith 7 mr johnny johnson 8 mrs robin white 9 miss allison williams 10 mrs erika king     Processors Flow   My not correct formatet temporary csv-output: temporary csv-output ... View more

@totti1  Oh, that's a shame and would have been to easy... 😉 Can you tell what other options you have tried? Can you provide information on what the data looks like? ... View more

@totti1  Haven't done this until now, but there is a ConvertExcelToCSVProcessor  Processor. Have you tried this? ... View more

@memad  Have a look here at the processor: To create or check cron syntax look here: https://www.freeformatter.com/cron-expression-generator-quartz.html   Hope this helps! Bye ... View more

@BerniHacker  Come on work can wait... Here my description with NiFi 1.12.1. on a windows standalone installation. This is my test csv. id;title;first;last 1;miss;marlene;shaw 2;ms;letitia;jordan 3;mr;todd;graham 4;mr;seth;martinez 5;mr;guy;mckinney 6;ms;anna;smith 7;mr;johnny;johnson 8;mrs;robin;white 9;miss;allison;williams 10;mrs;erika;king   This is my flow: Flow   This is my sql table. SQL table This is the configuration of the csv-reader. Note the green bordered information! Controller Service - dsv reader The schema has to be defined in a controller service of the type "AvroSchemaRegistry". AvroSchemaRegistry   With the UpdateAttribute you set the NiFi-attribute   schema.name  to the concrete schema you use. UpdateAttribute schema.name   And last but not least configure the PutDatabaseRecord. PutDatabaseRecord Here is the result in my sql table. SQL Result Hope this helps and works for you. Bye! ... View more