I am very new to NiFi, and I'm attempting to set up a very simple process to convert a CSV file to JSON. When the file comes in, I take the file name and use ExecuteSQL to look up some processing instructions, like the destination directory for the final output.
I hope this makes sense. If I can figure out how, I'll add images.
I would recommend to adjust the order so that you get the data you need from sql, parse it to attributes in the flow, and then pickup the csv.
If this answer resolves your issue or allows you to move forward, please choose to ACCEPT this solution and close this topic. If you have further dialogue on this topic please comment here or feel free to private message me. If you have new questions related to your Use Case please create separate topic and feel free to tag me in your post.
Steven @ DFHZ