I am still a beginner in using NIFI.
I would like to query a database & pull record on a daily basis. And each day record would be converted to CSV and write to a directory.
I have checked this method:
But i would like to know if there is any other simpler way of doing it.
Thank you so much.
You can set the run schedule of the processor to cron driven  and give it your cron expression from there.
Note that this cron is not the typical OS cron syntax and its based off quartz cron scheduler 
To build a cron expression this is a good online tool to do so